Re: OK SQL experts...
| From: | John W. Holmes | Date: | Fri, 23 Apr 2004 15:32:52 +0000 |
| Subject: | Re: OK SQL experts... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-184407@lists.php.net to get a copy of this message | ||
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...