Query Error
I made a chart with the wizard, uploaded it to my site, looked at the page and it just shows a chart with not data. I opened the data1.php file and took a look at the query. When I tried to test the query it gave me an error. I then loaded up the db in Navicate and tried to run the query against the db, again and error for the same thing DW was giving me an error. I don't see anything obvious as to why this is throwing an error ....
SELECT CONCAT(LEFT(MONTHNAME(creationDate), 3), ' ', DAY(creationDate), ',', YEAR(creationDate)) AS XLABEL, SUM(amountFound) AS YVALUE FROM tombsdb GROUP BY CONCAT(LEFT(MONTHNAME(creationDate), 3), ' ', DAY(creationDate), ',', YEAR(creationDate)), DAYOFWEEK(creationDate) ORDER BY creationDate ASC, DAYOFWEEK(creationDate) ASC
Any ideas as to what might be causing this error?
1064-You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(creationDate), ',', YEAR(creationDate)) AS XLABEL, SUM(amountFound)