PHP/mySQL query problem...
| From: | Jeff Lewis | Date: | Mon, 27 Aug 2001 18:09:20 +0000 |
| Subject: | PHP/mySQL query problem... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-64667@lists.php.net to get a copy of this message | ||
Guys, why isn't this working? :)
SELECT * FROM links WHERE name LIKE "%te%" OR description LIKE "%te%" OR url
LIKE "%te%" AND approved="1" LIMIT 5
I am using a PHP script to add items to the database and a small search file to grab them. Thing
is, I want the above to grab ONLY ones that have approved = 1. In the database they are all = 0.
Is there a problem with my SQL query?
Jeff