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.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
