Re: OK SQL experts...
| From: | John W. Holmes | Date: | Fri, 23 Apr 2004 17:39:19 +0000 |
| Subject: | Re: OK SQL experts... | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-184443@lists.php.net to get a copy of this message | ||
From: "Brian Dunning" <brian@briandunning.com>
> My error. Here is the actual return:
>
> 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 '%custom%' OR 'field_
>
> I am searching for the word "custom," which I put in at least one of
> the fields in several records, so the search SHOULD find something.
Take out the single quotes around your table name! If you must, use
backticks, but even they aren't necessary. Then tell us what the new error
is.
---John Holmes...