php mysql graph

[jawood]

Hi hoping someone can help with an issue im having displaying data from a MySQL database with php.

 

Attached is a copy of the code its the first graph at the top that I cant get to display the data.

 

It wont display the minutes along the bottom or draw the graph lines.

 

The page is located at www.inshome.net.au/dashboard.php

 

I have a feeling its to do with the getting the time from the table!

 

 

MYSQL table

 

id

event                 timestamp               current_timestamp

dht22temp         varchar(10)

humidity             varchar(10)

bmp180temp     varchar(10)

pressure            varchar(10)

altitude              varchar(10)

current0             varchar(10)

current1             varchar(10)

code.php

[Barand]

A MySql type TIMESTAMP is not a unix-style timestamp but yyyy-mm-dd hh-ii-ss format.

Try

SELECT 
  TIMESTAMPDIFF(MINUTE, event, NOW()) as time1
  , dht22temp
  , humidity
  , pressure 
FROM sensordata 
WHERE event > NOW()-INTERVAL 2 HOUR
ORDER BY Time

[jawood]

thanks I made the suggested change and still not getting any data displayed.

 

should it be ORDER BY time1 ?

[jawood]

That did it changing that last time to time1 thanks very much.

 

Thou can I ask just one other question How to do change the increments on the vertical axis from 300 600 900 to say from -10 to 1100 in steps of say 20