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_approved IN ('1', '2')
ORDER BY name ASC
Good luck!
-TG
----- Original Message -----
From: "ron.php" <ron.php@xxxxxxxxxxxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Date: Sat, 15 Sep 2007 15:04:59 -0400
Subject: Query syntax
> $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
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
