I have a query in MySQL that works fine, however when i copy the query over into my PHP file, it is throwing me a syntax error: ** unexpected ") as week_ending ** what am i missing?
MySQL:
'SELECT COUNT(*) as
count,region, DATE_FORMAT(NOW(),'%d %b %y') asweek_endingFROM stores.stats WHEREdate> DATE_ADD(DATE(NOW()), INTERVAL -1 WEEK) ANDdate< DATE(NOW()) GROUP BYregion, DATE(NOW())';
PHP:
$stmt = DB::query(Database::SELECT, 'SELECT COUNT(*) as
count,region, DATE_FORMAT(NOW(),'%d %b %y'), asweek_endingFROM stores.stats WHEREdate> DATE_ADD(DATE(NOW()), INTERVAL -1 WEEK) ANDdate< DATE(NOW()) GROUP BYregion, DATE(NOW())';