$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_type --- ie other variables) Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
