php pie chart from DB

[sonny]

Hi, I am trying to create a pie chart for diff browser versions
Like MSIE 9.0. FireFox etc

I have the chart code working, just looking for the best way
to get data from MySQL

example, this works fine
<img src="PieChart.php?data=1*3*5*10&label=MSIE 9.0*MSIE 8.0*MSIE 7.0*MSIE 6.0 />

what would be the best way to count and label results for chart?

Update works fine now

PHP Code:


$result1 = mysql_query("SELECT * FROM mytable WHERE ua LIKE '%MSIE 9.0%'"); 
$E9 = mysql_num_rows($result1);

$result2 = mysql_query("SELECT * FROM mytable WHERE ua LIKE '%MSIE 6.0%'"); 
$E6 = mysql_num_rows($result2); // etc.....

$data= "$E9*$E6";
$label = "MSIE 9.0*MSIE 6.0"; 


Thanks
Sonny

[koolphpnet]

It is better that you put all the browser type into an array first and loop through array to pull out result:

PHP Code:

$arr=array("Firefox","MSIE");
$data = "";
$label = "";
for(var $i=0;$<count($arr);$i++)
{
   $result = mysql_query("SELECT * FROM mytable WHERE ua LIKE '%".$arr[$i]."'");  
  $num = mysql_num_rows($result); 
  $data =  $num.(($=0)?"":"*");
  $label =  $arr[$i].(($=0)?"":"*");
} 


By the way here is an great interactive chart for PHP:

http://demo.koolphp.net/Examples/Koo...hart/index.php