Drawing Bar Graphs using GD/MySQL

Hi..

I’m having problem in this code !

I beileve it’s almost done, but just need a little fix !

here’s the code:
[B]image.php [/B]

[code=php]
<?php
//already been connected to database

$sql = “SELECT Status FROM Table1 GROUP BY Status”;
$x = mysql_query($sql) or die(“Error – Could not $sql” . mysql_error());

$sql = “SELECT COUNT(Items) FROM Table1 GROUP BY Status”;
$y = mysql_query($sql) or die(“Error – Could not $sql” . mysql_error());

//x= sold,shipped,InStock,UnKnown
//y= 8,6,3,5

$width = 300;
$height = 200;

header (“Content-type: image/png”);

$image = ImageCreate($width,$height) or die (“Cannot Create image”);

$white = ImageColorAllocate($image,255,255,255);
$black = ImageColorAllocate($image,0,0,0);
$red = ImageColorAllocate($image,255,0,0);
$green = ImageColorAllocate($image,0,255,0);
$blue = ImageColorAllocate($image,0,0,255);

$maxY = 0;
for ($i=0;$i<7;$i++){
if ($y[$i] > $maxY)$maxY=$y[$i];
}

ImageRectangle($image,1,1,319,239,$black);

imageLine($image,10,5,10,230,$blue);
imageLine($image,10,230,300,230,$blue);

ImageString($im,3,15,5,”CR ID”,$black);
ImageString($im,3,280,240,”Status”,$black);
ImageString($im,5,100,50,”Simple Graph”,$red);
ImageString($im,5,125,75,”by Lina”,$green);

$xPos = 15;
$yPos = 230;
$barWidth = 20;
$barHeight = 0;

for ($i=0;$i<3;$i++){
$barHeight = ($y[$i]/$maxY)* 100;
imagerectangle($image,$xPos,$yPos,$xPos+$barWidth,($yPos-$barHeight),$red);
imagestring( $image,2,$xPos-1,$yPos+1,$x[$i],$black);
imagestring( $image,2,$xPos-1,$yPos+10,$y[$i],$black);
$xPos += ($barWidth+20);
}

ImagePng($image, “graph.png”, 90);
?>
[/code]

[B]page.php[/B]

[code]
….
<img src=”image.php”/>
….
[/code]

[B]Error:[/B] after excuting page.php
The image “[url]http://websiteName.com/image.php”[/url] cannot be displayed, because it contains errors.

Also in #PHP _↴