Moving from Single Line to Multiline Charts in PHP and MySQL

[jgcrossman2]

I am a newbie but thanks to the documentation and hints from other users here, I have managed to get FusionCharts to work (via PHP) with a MySQL database (one critical post reminded me that values came before categories).

 

 

 

I would like to move forward into multiple lines and before I mess everything up, I thought I would ask for some advice.

 

 

 

Assuming I can keep my queries to MySQL straight, I foresee the big obstacle at my $FC line:

 

 

 

$FC->addDataFromDatabase($result, "perform", "date");

 

 

 

Can I use addCategoryFromDatabase plus two addDataFromDatabase $FC->'s (assuming I have two lines here and the same range of dates)?

 

 

 

Or do I try to cram it all into the addDataFromDatabase item?

 

 

 

Is there an example?

 

 

 

Thanks in advance for any assistance.

 

 

 

Regards,

 

 

 

John

[Guest Rajroop]

Hello,

Can I use addCategoryFromDatabase plus two addDataFromDatabase $FC->'s (assuming I have two lines here and the same range of dates)?

Yes, this is possible using FusionCharts.