jecourte

I'm am working on a graph to display discontinuous data from a mysql database into a multiseries chart. I would like to use functions like the ones talked about here: http://www.fusioncharts.com/docs/PHP_DB.html , the Build Dataset and Build Categories at the end of the page. I want to use date as the horizontal bar values, but the problem is that the database records don't have data for each date. Thus, the functions are generating poorly formed XML files which can't be read by a fusioncharts graph. It's not creating the same number of nodes because each date isn't represented. Does anyone have a function which helps with this? Thanks!

Output your XML somewhere so you can see what's being generated. If it's a multiseries chart you must have the same number of dataset entries as you do category entries, otherwise you'll get that error. Just make sure you use the exact same format as one of the sample xml's on this website that work. maybe this would help...