[SOLVED] php mysql query - how do I set to clauses on WHERE function?

[daveh33]

$query = mysql_query("SELECT * from messages WHERE roomid='$rid' & WHERE to='all'") or die (mysql_error());

 

This code isn't working for me - can anyone advise??

[trq]

SELECT * from messages WHERE roomid='$rid' && to='all';

[daveh33]

thanks but I get 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='all' Order by time' at line 1

 

the code is

 

$query = mysql_query("SELECT * from messages WHERE roomid='$rid' && to='all' Order by time") or die (mysql_error());

[trq]

Time is a reserved word. Try...

 

$query = mysql_query("SELECT * FROM messages WHERE roomid='$rid' && to='all' ORDER BY `time`") or die (mysql_error());

[daveh33]

Ah ok thats new to me - but I still get the 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='all' ORDER BY `time`' at line 1

 

there is 7 records in the mysql where the to field is all - I don't understand why it wont work

[trq]

Hmmm, funnily enough, to is a reserved word aswell.

 

$query = mysql_query("SELECT * FROM messages WHERE roomid='$rid' && `to`='all' ORDER BY `time`") or die (mysql_error());

[daveh33]

Ah - well at least I know that in future when naming my fields! That line works now, many thanks for your help