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
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.