Re: PHP/mySQL query problem...
| From: | ERISEN, Mehmet Kamil | Date: | Mon, 27 Aug 2001 18:38:16 +0000 |
| Subject: | Re: PHP/mySQL query problem... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-64676@lists.php.net to get a copy of this message | ||
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 <jeff@hyrum.net> 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/