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://www.php.net/unsub.php
