Hi List, does any one know how to create unique data series (arrays) per given category? For example: I would like to have a stacked bar graph hence needing series of data that belongs to each category in my category column.
An example would be, number of tickets by client over 6 months. I do not know how many client will be returned.
I do nto need SQL help.
This is what my SQL does:
mysql_connect("flame", "gopher", "********"); mysql_select_db ("reqmet"); $mysql_result = mysql_query ("SELECT Account, count(RequestID) as total,
date_format(Mo,'%Y-%m') as time from rfsrequests where Date_closed is not null
group by Account having count(requestID) > 10
order by Account, total
desc");
The resulting data needs to be assigned (hence my problem) to data series or arrays per Account. I am also unsure about how to then assign those arrays to a variable. (For anyone who cares, that variable then gets plugged into a jpgraph accumulated bar graph).
The function you need is mysql_fetch_array()
http://www.php.net/manual/en/function.mysql-fetch-array.php
-- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
