Re: Search Query on two tables not working
| From: | Miller, Terion | Date: | Tue, 21 Jul 2009 17:20:09 +0000 |
| Subject: | Re: Search Query on two tables not working | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-295631@lists.php.net to get a copy of this message | ||
Here it is...I see where it's doing the restaurant.name LIKE statement 2x which is prob messing
it up right...but in the code why is it doing that twice..
SELECT name, address, inDate, inType, notes, critical, cviolations, noncritical FROM restaurants,
inspections WHERE restaurants.name <> '' AND restaurant.ID = inspection.IDAND
restaurants.name LIKE '%A%' AND restaurants.name LIKE '%A%' ORDER BY
restaurants.name;
On 7/21/09 12:11 PM, "Dan Shirah" <mrsquash2@gmail.com> wrote:
print_r($sql);