Re: Query syntax
| From: | TG | Date: | Sat, 15 Sep 2007 19:57:07 +0000 |
| Subject: | Re: Query syntax | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-44015@lists.php.net to get a copy of this message | ||
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@actsministries.org>
To: php-db@lists.php.net
Date: Sat, 15 Sep 2007 15:04:59 -0400
Subject: [PHP-DB] 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
>
>