Im sorry, but It only displays the first value from the two datasets, in the chart?
<?php require_once('../../Connections/bucketListHub.php'); ?>
<?php require_once('../../webassist/mysqli/rsobj.php'); ?>
<?php
$data1 = '';
$data2 = '';
?>
<?php
$sql = new WA_MySQLi_RS("sql",$bucketListHub,1);
$sql->setQuery("SELECT * FROM chartTst");
$sql->execute();
?>
<?php
//loop through the returned data
while (!$sql->atEnd()) {
$data1 = $data1 . '"'. $sql->getColumnVal("data1").'",';
$data2 = $data2 . '"'. $sql->getColumnVal("data2") .'",';
$sql->moveNext();
}
$data1 = trim($data1,",");
$data2 = trim($data2,",");
?>