astralaaron Posted January 28, 2008 Share Posted January 28, 2008 $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 Link to comment Share on other sites More sharing options...
Ingolme Posted January 28, 2008 Share Posted January 28, 2008 Using the SQL AND operator:$q = mysql_query("SELECT * FROM `$id` WHERE box='inbox' AND status='unread'"); Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.