$query_Recordset1 = 'SELECT `Computer_ID` , `Diskio` , `dvd` , `h264` , `MPE_On` FROM `Personal_data`,`Benchmark_results` WHERE Personal_data.Ref_ID = Benchmark_results.Ref_ID ORDER BY Rank ASC LIMIT 0, 20' ;
$Recordset1 = mysql_query($query_Recordset1, $mysql) or die(mysql_error());
This results in a correct list, but when displayed in a graph, the first record is left out:
Secondly, the names do not display correctly. For instance:
Harm's Beast is changed to Harm&apos. This happens all the time.
Finally I want to have a stacked chart, which I believe can only be stacked columns. That can be overcome, but how do I create a stacked column chart? All the examples are centered around static content, not dynamic content from mySQL.
Is there a function like 'addChartDataFromDatabase' that I can use?
The php file is included for reference. Charts.php 1.52K 42 downloads