Query syntax
| From: | ron.php | Date: | Sat, 15 Sep 2007 19:04:59 +0000 |
| Subject: | Query syntax | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-44013@lists.php.net to get a copy of this message | ||
$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