My query looks like this
$numresults = mysql_query("SELECT town, list_price, bedrooms, baths, rooms, Id ,IF (lister_office_name like '$client_name',1, 0)
AS featured
FROM residential
WHERE ( $selecttownstring )
AND list_price BETWEEN $lowprice AND $highprice
AND bedrooms like '$bedroomsel'
AND baths like '$bathselect'
ORDER BY featured DESC, list_price DESC
")
I would like to add another variable to this statement
IF (lister_office_name like '$client_name',1, 0)
Something like
IF (lister_office_name like '$client_name' or '$client_name2',1, 0)
I cant seem to get a second varible to work. Any ideas?
