Little help -

[astralaaron]

$q = mysql_query("SELECT * FROM `$id` WHERE box='inbox'");this query will pull all rows where the box column = inboxi would like to know how i can add another column to match up also$q = mysql_query("SELECT * FROM `$id` WHERE box='inbox' & status='unread'");how can i write that? i know there must be a way! please help

[Ingolme]

Using the SQL AND operator:$q = mysql_query("SELECT * FROM `$id` WHERE box='inbox' AND status='unread'");