[PHP] PHP/mySQL query problem...

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

Re: [PHP] PHP/mySQL query problem...

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