Hi,
I am trying to get an array of fillingstocks to output in a bargraph.
(Program used for this is chartdirector
If I do the query and output it to the browser everything seems ok - if I
try to output the result via the graph it looks like if it's only using the
last result (I'm only getting a block instead of bars).
/* connection details */
$connection = mysql_connect($server, $user, $pass)
or die ("Couldn't connect to server.");
$db = mysql_select_db($dbname, $connection)
or die ("Couldn't select database $db.");
/* query and other variables */
$order="datum desc";
$sql="SELECT * from $table WHERE $sap ORDER BY $order LIMIT 0,15"
or die ("Couldn't do sql $sql,");
/* get the data and the labels for the bar chart */
$result = mysql_query($sql);
$row = mysql_num_rows($result);
while ($row = mysql_fetch_object($result)) {
$data = $row->liter;
$labels = $row->date;
}
Any suggestions? Please help - I'm going mad with this problem !!!
Thanks in advance,
Ekkehard
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
