Re: OK SQL experts...

Yes, I've checked and rechecked the spelling on everything. I've been testing with a word that I know appears in at least one of the fields. On Apr 23, 2004, at 8:54 AM, Edward Peloke wrote:

what value is being put in the $keyword variable? You are sure all these columns exist? -----Original Message----- From: Brian Dunning [mailto:brian@briandunning.com] Sent: Friday, April 23, 2004 11:36 AM To: php-general@lists.php.net Subject: Re: [PHP] OK SQL experts... Backticks, single quotes, or nothing at all makes no difference. I believe the parsing error is due to my parentheses or AND/OR structure. Any thoughts on that? On Apr 23, 2004, at 8:32 AM, John W. Holmes wrote:

From: "Brian Dunning" <brian@briandunning.com>

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';

Use backticks around table and column names, not single quotes. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

- Brian -- 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 - Brian