Re: OK SQL experts...
| From: | Brian Dunning | Date: | Fri, 23 Apr 2004 15:29:58 +0000 |
| Subject: | Re: OK SQL experts... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-184405@lists.php.net to get a copy of this message | ||
It gives the same error when I run it in phpmyadmin.
On Apr 23, 2004, at 8:34 AM, Edward Peloke wrote:
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:brian@briandunning.com] Sent: Friday, April 23, 2004 11:23 AM To: php-general@lists.php.net 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:brian@briandunning.com] Sent: Friday, April 23, 2004 11:19 AM To: php-general@lists.php.net 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 - Brian