does it just return the error when running in the php page? If you pull it out can you run it in mysql without errors?
-----Original Message----- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Friday, April 23, 2004 11:23 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] OK SQL experts... I tried it both ways - didn't make any difference (phpmyadmin adds the single quotes when I was trying to use its sql function to debug, so I figured what the hell)... On Apr 23, 2004, at 8:27 AM, Edward Peloke wrote: > why are the table and field names surrounded by single quotes? > > -----Original Message----- > From: Brian Dunning [mailto:[EMAIL PROTECTED] > Sent: Friday, April 23, 2004 11:19 AM > To: [EMAIL PROTECTED] > Subject: [PHP] OK SQL experts... > > > 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 > > -- > 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
