Error is absolute. Don't use " (double quotation mark) in yur queries. Use ' (single quot.) instead
$query = "SELECT DATE_FORMAT( exp_date, '%W, %M > %d, %Y') AS thedate from tifrequest where user='$user' limit 1,1"; Because the preprocessor think that your string is finished when it sees a double quot. And use a colorful editor. that helps u seeing errors like this. :) martina "Robert McPeak" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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
