Yes, there is a problem.
--
SELECT *
FROM links
WHERE 1=1
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?
>
> Jeff
>
=====
Mehmet Erisen
http://www.erisen.com
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
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]