Home forums Using CanvasJS Creating Dynamic Graphs on a PHP page based off MySQL data Reply To: Creating Dynamic Graphs on a PHP page based off MySQL data

#19892

Indranil Deo
Member

@lindsay10c,

The query seems to have some issue. Comparing timestamp properly should work fine in your case, i.e. SELECT timestamp, count FROM skelCount WHERE timestamp >= TIMESTAMP(DATE_SUB(NOW(), INTERVAL 1 day)) should work fine in this scenario. Please take a look at this link for more info. Please take a look at the updated project. Below is the screenshot of the chart when its run in local-server.
php charts with data from mysql db

___________
Indranil Deo
Team CanvasJS