Thanks El Cuy, Joshua, Ryan,
Let me be more specific about making graphs with MySQL data.
Currently my project is in development phase,
using MS Access as front-end and MySQL as back-end with MyODBC.
My next step is to replace the MS Access front-end by PHP
(because I don't see any use of MS Access for a website).
However, I don't have any experience with PHP yet.
Before moving to PHP, I would like to test some chart possibilities,
with bar charts, line charts etc.
I am thinking of a charting engine as a "runtime component",
that makes charts depending on passed parameters, such as:
a) the result of a MySQL query or the query itself
b) parameters to specify the charttype, title etc.
Ryan wrote that MS Access/MyODBC could do it, but how ?
Joshua wrote that MS Excel (and OO Calc) could do it,
but then I have to instruct MS Excel how to chart per query ?
To give an idea of my chart needs:
http://www.ecb.int/stats/exchange/eurofxref/html/eurofxref-graph-usd.en.html
Regards, Cor
----- Original Message -----
From: "El Cuy Volador" <[EMAIL PROTECTED]>
To: "C.R.Vegelin" <[EMAIL PROTECTED]>; <mysql@lists.mysql.com>
Sent: Saturday, January 13, 2007 1:29 AM
Subject: Re: making graphs with MySQL data
C.R.Vegelin escribió:
Dear List,
I have a MySQL database (V5.0.x) and I need to make graphs.
Does anyone know about good utilities to make graphs ?
I would appreciate your expertise or links.
TIA, Cor
A very good one is BIRT (http://www.eclipse.org/birt/phoenix/) to be
deployed in a Tomcat or any other Java server. You can see some
tutorials and video tutorials in the examples section of the page. Very
easy to use.
If you are using PHP, an option is jpgraph
(http://www.aditus.nu/*jpgraph*/). Not very complete, and quite
difficult to deploy.
A commercial solution is Fusion Charts
(http://www.infosoftglobal.com/FusionCharts/).
Try to be a little bit more explicit about the language you are using
ant the kind of graphs you need to generate.
Hope this links help you,
Regards,
Alvaro
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
