doesn't look like your $keyword value contains anything.
-----Original Message-----
From: Brian Dunning [mailto:[EMAIL PROTECTED]
Sent: Friday, April 23, 2004 1:19 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] OK SQL experts...
On Apr 23, 2004, at 10:13 AM, John Nichel wrote:
> Brian Dunning wrote:
>> I STFW and RTFM and I still can't figure out why this returns a 1064
>> parse error:
>> SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR
>> 'field_2' LIKE '%$keyword%' OR 'field_3' LIKE '%$keyword%') AND
>> 'status' = 'active';
>> Anyone? TIA!
>> - B1ff Lamer
>
> What does mysql_error() tell you?
You have an error in your SQL syntax. Check the manual that corresponds
to your MySQL server version for the right syntax to use near
''my_table' WHERE ('field_1' LIKE '%%' OR 'field2'
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
