Last 24 hours on X axis from mysql

[aMoN75]

Hello,

I want to generate a chart from mysql results with this table :

I need to have last 24 hours on X axis, Y axis got the number of reports (Its ok)

here is code :

https://jsfiddle.net/g3L8f4hm/

Than you a lot for your help,

[aMoN75]

I can’t edit my message, but i want this result : https://i.imgur.com/l6aqsId.png

[Ananya]

@amon75,

Please take a look at this gallery page for an example on rendering chart with data fetched from MySQL database. you can also refer to this page for an article about the same.

—
Ananya Deka
Team CanvasJS

[aMoN75]

Yes i know how to populate results in the graph from mysql, i need the correct sql syxtax for this final result : https://i.imgur.com/xrI9R5m.png

[Ananya]

@amon75,

Please refer to this Stack Overflow thread for more information on fetching last 24 hours’ data from database. You can pass the fetched data to the chart and render it.

—
Ananya Deka
Team CanvasJS