$query = "SELECT DATE_FORMAT( exp_date, \"%W, %M %d, %Y\") AS thedate from tifrequest where user='$user' limit 1,1";
Missing escape \ in front of quotes -----Original Message----- From: ROBERT MCPEAK [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 1:55 PM To: [EMAIL PROTECTED] Subject: [PHP] parse error, mysql select When I execute from browser I get a parse error, but when I enter the query directly into a MySQL command prompt I get a successful return. Can anybody see the problem with this code: $query = "SELECT DATE_FORMAT( exp_date, "%W, %M %d, %Y") AS thedate from tifrequest where user='$user' limit 1,1"; Thanks! My eyes are shot! -- 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
