Hi All,

I am currently converting my existing php chartjs pages over to wordpress using the wpdatatables.

Could I ask how to filter the query by day. I currently use = DATE(NOW) but I am not sure this works in this environment.

here is the query I am trying

SELECT temperatures.`dateMeasured`,
       temperatures.`temperature`,
       temperatures.`hourMeasured`
FROM temperatures 
WHERE temperatures.`dateMeasured` = DATE(NOW)

but I must have the syntax wrong

any help would be appreciated

Thanks

Wayne

Hi All,

Sorry I realised what I had done. I went via the "Generate a query to MySQL database" option but needed to go via the "Create a table linked to an existing data source" this works perfectly with my existing sql queries.

Thanks

Wayne