Bar chart in php

[Anon]

hello all,
Can anybody tell me how to write a bar chart program in php for the data retrieved from the mysql
i mean any sample code for generating bar chart for showing teh statistics of results.

any help appreciated
akanksha

[Anon]

I think you'll be able to pick up something to do the job somewhere in the code archives at Zend (www.zend.com)

[robro]

Since I can't see your mysql table I will have to make a few asumptions.

i am assuming the following MySQL table.

+-------+-----------+
|name | novotes |
|-------+-----------+
|apple | 10 |
|orange | 20 |
|bannana| 15 |
+-------+-----------+

<?
$sql="select * from stuff";
$m=mysql_query($sql);
echo "<table>\n";

while($data=mysql_fetch_assoc($m){
echo "<tr><td>$data[name]</td><td><img src="pic.gif" height=\"10\" width=\"$data[novotes]\"></td></tr>";
}
echo "</table>";
?>

I haven't tested that. You need a picture called pic.gif.

[james2010]

You might want to consider using the gd functions to do this.