Can someone help me out with a mysql query?

I am trying to get a list of rows that match one of two category columns that are in a city. Im sure IN isn't valid syntax for queries so can someone help me out?

PHP Code:

mysql_query("SELECT * FROM restaurants WHERE cat=$cat AND subcat=$cat IN city=$city",$db) 


Thanks if anyone can help

The , $db isn't necessary, and the IN is incorrect; doesn't exist. You must also quote the comparison. Try this:

PHP Code:

$query = mysql_query("SELECT * FROM restaurants WHERE cat='$cat' AND subcat='$cat'");
while ($output = mysql_fetch_array($query)){
    echo $output[arrayVALUE].'<br>';
} 


Thanks Logical Program but I just posted a portion of the code I have all that. With that out of the way can anyone help me with the problem.

The corrected version of your portion was in the $query variable.

Maybe im confused.. My query works fine this is the section that im trying to change

PHP Code:

$result = mysql_query("SELECT * FROM restaurants WHERE cat=$catid",$db);
    
    if ($r_row = mysql_fetch_array($result)) { 


So right now this work fine, it shows every row that matches the cat column. but im trying to select only the rows that are in the city column which $cat matchs cat and subcat columns.

Is this possible?

I'm lost... You can't have rows in a column. Is city a field in the restaurants table? IF so, try:

PHP Code:

mysql_query("SELECT * FROM restaurants WHERE city='$x' AND cat='$cat' AND subcat='$cat'"); 


Yes! thats what im looking for.. Sorry i was a bit unclear before, i dont know what im talking about. =)

Glad I could help; You were losing me there for a second.