creating unique data series per category

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). Any ideas? TIA, RS This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.