Soldato
Evening all,
OK, so I have a MySQL database with some data (suprisingly enough), one field of which is a UNIX timestamp. Another of these is "temperature".
Now a record is added to the database automatically every fifteen minutes. Somehow I'd like to automatically pick out data from the database and generate a graph of the temperatures over the last 24 hours. Ie. Time along the x-axis and temperature up the y-axis.
I've had a look at things like JPGraph, but I'm not very experienced with PHP and MySQL (I've done a reasonable amount, but by no means am I an expert). Is this the best way to go about doing this?
The basic concepts of JPGraph I understand, but how would I extract the data from the database into an array that I can then feed into JPGraph? And how do I get time along the x-axis?
Thanks for any help, it really is appreciated!
Jon
OK, so I have a MySQL database with some data (suprisingly enough), one field of which is a UNIX timestamp. Another of these is "temperature".
Now a record is added to the database automatically every fifteen minutes. Somehow I'd like to automatically pick out data from the database and generate a graph of the temperatures over the last 24 hours. Ie. Time along the x-axis and temperature up the y-axis.
I've had a look at things like JPGraph, but I'm not very experienced with PHP and MySQL (I've done a reasonable amount, but by no means am I an expert). Is this the best way to go about doing this?
The basic concepts of JPGraph I understand, but how would I extract the data from the database into an array that I can then feed into JPGraph? And how do I get time along the x-axis?
Thanks for any help, it really is appreciated!
Jon