hi i hope some one can help me with this i am a real php noob i am trying to create a graph using mysql data with jpgraph it is going to show 7 temputures over a week so date at bottom from mysql with the diferent color lines showing the differnt sensors temp just need help on how to get started
[IMG]http://i52.tinypic.com/2d1mhkg.png[/IMG]
[IMG]http://i51.tinypic.com/55347k.jpg[/IMG]
i have posted some pics on my mysql layout and what i need with jpgraph
thank you
Not familiar with jpgraph, but I assume your DB table should be something like:
id | `day` | startweek | temp1 | temp2 | temp3
where temp1,2,3 are the different datasets (lines)
The day/startweek field relates to the ABCD in the image, e.g. day being the integer field 0 - 6 or 1 - 7.
OR, you could just have a single date field (instead of day/startweek), in order to get the trend between any two dates.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.