Re: OK SQL experts...
| From: | John Nichel | Date: | Fri, 23 Apr 2004 17:13:23 +0000 |
| Subject: | Re: OK SQL experts... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-184435@lists.php.net to get a copy of this message | ||
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 LamerWhat does mysql_error() tell you? -- *********************************************************************** * _ __ __ __ _ * John Nichel * * | |/ /___ __ \ \ / /__ _ _| |__ ___ __ ___ _ __ * 716.856.9675 * * | ' </ -_) _` \ \/\/ / _ \ '_| / /(_-<_/ _/ _ \ ' \ * 737 Main St. * * |_|\_\___\__, |\_/\_/\___/_| |_\_\/__(_)__\___/_|_|_|* Suite #150 * * |___/ * Buffalo, NY * * http://www.KegWorks.com john@KegWorks.com * 14203 - 1321 * ***********************************************************************