Re: [PHP] OK SQL experts...

[Brian Dunning]

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" <[EMAIL PROTECTED]>

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