Yes, there is a problem.
and ( name LIKE "%te%"
OR description LIKE "%te%"
OR url LIKE "%te%" )
AND approved="1" LIMIT 5;
--- Jeff Lewis <[EMAIL PROTECTED]> wrote:
> 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?
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]