I am trying to display a table based on session username but I am getting the following error. When it is id
it is working but when it is username
it is not
SELECT tb_list.* FROM tb_list
WHERE myusername = ".Session::get('username')."
QueryException in Connection.php line 662: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY id asc LIMIT 0 , 10' at line 2 (SQL: SELECT tb_list. FROM tb_list WHERE username = ORDER BY id asc LIMIT 0 , 10 )*
Thanks in advance
Lets say the session owner's username is john
Table with NO session
WHERE tb_list.task_id IS NOT NULL
+---------+----------+-------------+-----------------+
| task_id | username | some_data | some_time |
+---------+----------+-------------+-----------------+
| 1 | john | some data | 2015-02-29 1 pm |
| 2 | jack | some data | 2015-02-29 2 pm |
| 3 | john | some data | 2015-02-29 3 pm |
| 4 | bill | some data | 2015-02-29 4 pm |
+---------+----------+-------------+-----------------+
Table with john's session
WHERE username=".Session::get('username')."
+---------+----------+-------------+-----------------+
| task_id | username | some_data | some_time |
+---------+----------+-------------+-----------------+
| 1 | john | some data | 2015-02-29 1 pm |
| 3 | john | some data | 2015-02-29 3 pm |
+---------+----------+-------------+-----------------+