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 descr
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
2 matches
Mail list logo
