I am considering a chart program but I am not sure I I can use jqchart.
I get data using mysql (with PHP, not ASP).
So in this jqchart example for a line chart:
$('#jqChart').jqChart({
title: { text: 'Line Chart' },
series: [
{
type: 'line',
title: 'Series 1',
data: [[1, 62], [2, 60], [3, 68],
[4, 58], [5, 52], [6, 60], [7, 48]]
},
{
type: 'line',
title: 'Series 1',
data: [[1, 46], [2, 40], [3, 62],
[4, 65], [5, 60], [6, 36], [7, 70]]
}
]
});
But this is an example where you know the data which is not real-world. How would I insert data from a query?
The form I have is in an array. like $row[field]
I would get each value in $row[field] with a while loop. How do I put a while loop into the jqchart script?