efonseca

offcourse it wouldnt work. i was trying to see a multi on a single... i'm so dummmm tks for all your help.. all tested all working going to upgrade.. tks regards Eduardo

Hi After de correction that you propose i get the "No data to display" the XML looks as before.. Best Regards Eduardo

maybe this can help code.txt Regards EF

how do i do that? all the code is in a HTML/PHP file.

chart_ChartId.setDataXML(" categories> category label='AAD'/> category label='CA?'/> category label='CGT'/> category label='CMP'/> category label='CNT'/> category label='COM'/> category label='DAF'/> category label='DCE'/> category label='DGE'/> category label='DID'/> category label='DMN'/> category label='GES'/> category label='INF'/> category label='LAB'/> category label='OPA'/> category label='QLA'/> category label='RH'/> category label='SSG'/> category label='TSR'/> /categories> dataset seriesname='Total'> set value='1' /> set value='2' /> set value='2' /> set value='2' /> set value='4' /> set value='45' /> set value='1' /> set value='3' /> set value='1' /> set value='4' /> set value='29' /> set value='1' /> set value='2' /> set value='9' /> set value='29' /> set value='2' /> set value='3' /> set value='2' /> set value='2' /> /dataset> dataset seriesname='Avaliados'> set value='0'/> set value='0'/> set value='0'/> set value='0'/> set value='0'/> set value='8'/> set value='1'/> set value='0'/> set value='0'/> set value='4'/> set value='0'/> set value='0'/> set value='1'/> set value='0'/> set value='0'/> set value='0'/> set value='0'/> set value='2'/> set value='0'/> /dataset> /graph>") chart_ChartId.render("ChartIdDiv");

i've triyed like this but i get a invalid xml data.

hi i'm a newbiee in XML and PHP how can i get more than one set from a DB connection from the example below how can i get a chart with Total and Avaliados.. or more if needed $link = connectToDB(); $useUTFQuery = "SET NAMES 'utf8'"; $utfQueryResult = mysql_query($useUTFQuery); $strQuery = "SELECT Dep, Count(*) AS Total FROM, Count(DataAval) AS Avaliados DAI_main GROUP BY Dep"; $result = mysql_query($strQuery) or die(mysql_error()); $strXML = "graph decimalPrecision='0' rotateNames='0' xaxisname='Departamentos' yaxisname='Colaboradores' showBorder='0' showPercentageValues='0' showPercentageInLabel='0' >"; if ($result) { while($ors = mysql_fetch_array($result)) { $strXML .= "set name='" . $ors['Dep']."' value='" . $ors['Total'] . "' color='FDC12E'/>"; } } mysql_close($link); $strXML .= "/graph>"; echo renderChart("Charts/FCF_Column3D.swf", "", $strXML, "ChartId", 650, 450, false, false); ?> Note: < is taken off so all code can be see