Re: OK SQL experts...
| From: | Curt Zirzow | Date: | Fri, 23 Apr 2004 17:33:21 +0000 |
| Subject: | Re: OK SQL experts... | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-184439@lists.php.net to get a copy of this message | ||
* Thus wrote Brian Dunning (brian@briandunning.com):
>
> 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'
Because you are using a single quotes around your table/field
names. Remove them or use ` (back tick). As suggested earlier.
Curt
--
"I used to think I was indecisive, but now I'm not so sure."