hai i want to create bar chart .........i got some code from net but its gets only static vertical chart bar....
the values are as foolows :
$values=array(
"Jan" => 110,
"Feb" => 130,
"Mar" => 215,
"Apr" => 81,
"May" => 310,
"Jun" => 110,
"Jul" => 190,
"Aug" => 175,
"Sep" => 90,
"Oct" => 286,
"Nov" => 150,
"Dec" => 196
);
its working fine but want dynamic chart bar my query are:
$sql=mysql_query("SELECT Category, COUNT( StudentID ) as Sum FROM studentregdtb GROUP BY Category");
$b=mysql_fetch_assoc($sql);
so how can i get value like the above $values arrays.
i had used this $b=mysql_fetch_assoc($sql);
but output are:
Array
(
[0] => OBC
[Category] => OBC
[1] => 24
[Sum] => 24
)
Array
(
[0] => SC
[Category] => SC
[1] => 37
[Sum] => 37
)
Array
(
[0] => ST
[Category] => ST
[1] => 2
[Sum] => 2
)
but i need like
Array
(
[Jan] => 110
[Feb] => 130
[Mar] => 215
[Apr] => 81
[May] => 310
[Jun] => 110
[Jul] => 190
[Aug] => 175
[Sep] => 90
[Oct] => 286
[Nov] => 150
[Dec] => 196
)
Graph Chart problem..........
Moderator: General Moderators
-
manojsemwal1
- Forum Contributor
- Posts: 217
- Joined: Mon Jun 29, 2009 4:13 am
- Location: India
-
manojsemwal1
- Forum Contributor
- Posts: 217
- Joined: Mon Jun 29, 2009 4:13 am
- Location: India
Re: Graph Chart problem..........
Pl help to solve this problem................. 