'from='jacop' AND deleted='0' '' at line 1

[etsted]

Can someone tell me whats wrong with this code? I just cant see it

        $sql = "SELECT * FROM conversation WHERE from='$log_username' AND deleted='0' ";

error caused: 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 'from='jacop' AND deleted='0' '' at line 1

[Ingolme]

FROM is an SQL keyword, so you'll have to wrap it in backticks:

`from`='$log_username'

[etsted]

got this error: 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 'to, from, date_sent, message, subject FROM conversation WHERE `from`='jacop' AND' at line 1

 

while trying this:

$sql = "SELECT id, to, from, date_sent, message, subject FROM conversation WHERE `from`='$log_username' AND deleted='0' ";

[Ingolme]

Actually, the same problem is occurring because you have another "from" in the query.

SELECT id, to, from,

[justsomeguy]

"To" is also a reserved word.http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html