i cant give you a working link but can try explain you now
chd= ( this is your value variable from GET true ?)
when you use Line method from api chd value is start from 1 to 100 its
mean value working with % parameters so
you must do something like that
$countUsers=$DBCONN->getRows("select count(userID) as num from
users");
$countUsers=$countUsers[0]['num']; // this is like 248
$countOn1=$DBCONN->getRows("select count(favoriteStyleInSalsaID) as
num from users where favoriteStyleInSalsaID=2");
$countOn1=$countOn1[0]['num']; // this is like 126
$countOn1=number_format($countOn1); // this is like 126
$countOn1yuzde=number_format($countOn1*100/$countUsers); // what we do
here 126*100/248=51 (percent or %)
hope you know php what we do in upper code
get the users count from DB and get the users count who danceing salsa
On1 from DB then use number_format($countOn1*100/$countUsers); this
mathematic function and get percent of users who danceing On1 Salsa
Style what is the value become like 56
ok now you can use $countOn1 for you chart on chd=
example:
http://chart.apis.google.com/chart?chs=1000x300&cht=lc&chxt=x,y&chco=...13:50|13:55|13:50|13:55|13:50|13:55|13:50|&chd=t:0,40,20,65,85,100,75|0,10,60,100,80,70,100&chxr=1,0,500&chdl=Line1|Line2
sorry for my bad english :D
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google Chart API" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/google-chart-api?hl=en
-~----------~----~----~----~------~----~------~--~---
