MySQL Error

Quadodo

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='Quadodo' AND read='Unread'' at line 1

Code:

$num_private=mysql_query("SELECT * FROM ".$prefix."private WHERE to='$username' AND read='Unread'") or die(query_error());

Now, I've tried just about everything to get this to work, according to:
http://dev.mysql.com/doc/refman/5.0/en/selecting-rows.html

It should work fine. Any idea why it isn't?

Houdini

is &prefix defined somewhere in the script?

Quadodo

Yes.

Houdini

Have you tried using the actual value of $prefix (which is usually for a database and not a table) and have you echoed the query to see just what MySQL sees. You don't have alot of code to work with here.

Quadodo

Well, the syntax of putting the prefix works fine everywhere else because I have like 100 queries with it, also I have a query almost the same as the one with the error:

$get_group=mysql_query("SELECT * FROM ".$prefix."groups WHERE (low<$userposts AND high>$userposts)") or die(query_error());

That works fine.