get Roxen :)
You can do it very easily... example:
<diagram type=line width=600 height=500 name='title' vertgrid horgrid
tonedbox='lightblue,lightblue,white,white'>
<data xnamesvert xnames form=column separator=,>
<sqloutput host=remedy query="SELECT DATE_FORMAT(date,'%b %D') as date, appsq, dialq
FROM qtimes WHERE date >= '+fromdate+' AND date <= '+todate+' AND
time='08:00:00';">
#date#,#appsq#,#dialq#
</sqloutput>
</data>
<legend separator=,>Applications Group,Dialup Group</legend>
<xaxis quantity=Date>
<yaxis quantity=Tickets>
</diagram>
-Graeme
miral said:
>
> Dear all,
> Does anyone know how to create a chart from mysql query with php3 ??
>
> Regards
> -miral-
