[faye]

Hi all ,



i want query a single table to show the % for Axis y and fileter name as Axis X. I try to run this php, it display a wrong sql query.

Quote

sFILTER nPERCENTAGE



a 30



b 10



c 20



d 40

Quote

$link = connectToDB();







$strXML = "";



$strQuery = "select nPERCENTAGE from tblstats";

$result = mysql_query($strQuery) or die(mysql_error());



if ($result) {

while($ors = mysql_fetch_array($result)) {

$pri_ = $ors['sFILTER'];

$os = $ors['nPERCENTAGE'];



$strXML .= "";



mysql_free_result($result);

}

}

mysql_close($link);







$strXML .= "";





echo renderChart("../FusionCharts/Charts/FCF_Column3D.swf", "", $strXML, "FactorySum", 600, 300);

?>

Please help me to find out my sql query problems.

Thanks

faye

[Rajroop]

Hey,



Welcome to the FusionCharts Forum!

Quote

$strQuery = "select nPERCENTAGE from tblstats";

Here, you have used only 'nPERCENTAGE'.

Quote

$pri_ = $ors['sFILTER'];

$os = $ors['nPERCENTAGE'];

However, in your code you are using 'sFILTER' and 'NPERCENTAGE' both. Thereby causing the error you are facing.



You can modify your query like :

$strQuery = "select sFILTER,nPERCENTAGE from tblstats";



I hope this helps. Looking forward to your updates on this issue.

[faye]

Hi,



Thanks for reply.. Finally i query the correct mysql d..

Thanks for help too..





Regards

fy

[Basundhara Ghosal]

Hi,

We are glad that your issue is resolved.

Keep smiling and keep FusionCharting.