Hi All,

I have been looking at this: http://www.maani.us/xml_charts/.

What this does, is it allows you to create an XML file, then from a HTML page this XML file gets called as the source, and a graph is created. The HTML page is basic, and has Javascript which looks like this:

Code:
<script language="JavaScript" type="text/javascript">
<!--
if (AC_FL_RunContent == 0 || DetectFlashVer == 0) {
	alert("This page requires AC_RunActiveContent.js.");
} else {
	var hasRightVersion = DetectFlashVer(requiredMajorVersion, requiredMinorVersion, requiredRevision);
	if(hasRightVersion) { 
		AC_FL_RunContent(
			'codebase', 'http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,45,0',
			'width', '400',
			'height', '250',
			'scale', 'noscale',
			'salign', 'TL',
			'bgcolor', '#777788',
			'wmode', 'opaque',
			'movie', 'charts',
			'src', 'charts',
			'FlashVars', 'library_path=charts_library&xml_source=sample.xml', 
			'id', 'my_chart',
			'name', 'my_chart',
			'menu', 'true',
			'allowFullScreen', 'true',
			'allowScriptAccess','sameDomain',
			'quality', 'high',
			'align', 'middle',
			'pluginspage', 'http://www.macromedia.com/go/getflashplayer',
			'play', 'true',
			'devicefont', 'false'
			); 
	} else { 
		var alternateContent = 'This content requires the Adobe Flash Player. '
		+ '<u><a href=http://www.macromedia.com/go/getflash/>Get Flash</a></u>.';
		document.write(alternateContent); 
	}
}
// -->
</script>
As you see, the only portion which references the XML file is FlashVars', 'library_path=charts_library&xml_source=sample.xml'.

Using data from a MySQL database I am looking at creating the XML, but how can I do this dynamically? I dont want to create a new XML file everything a user wants to see a new graph, but it seems the above javascript needs to reference a physical file?

Alternatively, if there are any other ways to create nice graphs input is appreciated.