$query="SELECT * FROM table WHERE listing_type LIKE '%$listing_type%' AND
listing_approved = '1' OR listing_approved = '2' ORDER BY name ASC";
My question is how can I search for records where listing_approved has a
value of either 1 or 2 (while in the same search I am searching for
listing_ty
If I understood you correctly (and I'm not sure I did), this should do
it
$query="SELECT * FROM table WHERE listing_type LIKE '%$listing_type%'
AND listing_approved IN( '1' ,'2') ORDER BY name ASC";
--
Niel Archer
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http:
SELECT * FROM table
WHERE listing_type LIKE '%$listing_type%'
AND (listing_approved = '1' OR listing_approved = '2')
ORDER BY name ASC
(notice the parentheses around the OR part of the clause)
or you can do this...
SELECT * FROM table
WHERE listing_type LIKE '%$listing_type%'
AND listing_approv
