[RESOLVED] Mysql query with more than one WHERE statement?

ace19xx

Hey guys, I am trying to get some information from my database with a mysql query.
Is it to possible to user more than 1 "WHERE" statement?

Original:

$notification_query = mysql_query("SELECT * from notifications WHERE userid='$user_id' ORDER BY id DESC");
$notification_num_rows = mysql_fetch_array($notification_query);

I want to do something like this:

$notification_query = mysql_query("SELECT * from notifications WHERE userid='$user_id' [COLOR="Red"]AND read='0'[/COLOR] ORDER BY id DESC");
$notification_num_rows = mysql_fetch_array($notification_query);

Thanks in advance! 🙂

ace19xx

Ignore the tag, i ****ed up something when i wrote the post 🙂

JVassie

It is very simple to have two conditions in a MySQL query, tidying up what you wrote, you've got it correct 🙂

I assume id and userid are two seperate fields?

$notification_query = mysql_query("SELECT * from notifications WHERE userid='$user_id' AND read='0' ORDER BY id DESC");

ace19xx

JVassie;10973708 wrote:
It is very simple to have two conditions in a MySQL query, tidying up what you wrote, you've got it correct 🙂

I assume id and userid are two seperate fields?
$notification_query = mysql_query("SELECT * from notifications WHERE userid='$user_id' AND read='0' ORDER BY id DESC"); 

I also thought that would work, but what happened to me when I did this was the following:

 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 'read='0' ORDER BY id DESC' at line 1

Thank you anyways! 🙂

Any suggestions?..

ace19xx

and yes, the id and userid are 2 sepereate fields 🙂

bradgrafelman

READ is a MySQL Reserved Word, thus it's not being treated as if it was an identifier (e.g. the name of a column).

Thus, you either must delimit it with backticks (or double quotes, depending on the mode MySQL is in) or, better yet, pick a column name that isn't a reserved word as well.