scrollcolumn2d with sql query

[tstellman]

I have successfully created a column2d chart with the code below but when I change the chart type to scrollcolumn2d it doesn't render anything, it just states "no data to display."

 

if ($chartResult) {

$arrData = array(

"chart" => array(

"caption"=> "Sales Trends",

"subcaption"=> "FY 2012 - FY 2013",

"xaxisname"=> "Agency No.",

"yaxisname"=> "Pounds",

"showvalues"=> "1",

"placeValuesInside"=> "1",

"rotateValues"=> "1",

"valueFontColor"=> "#ffffff",

"baseFontColor"=> "#333333",

"baseFont"=> "Helvetica Neue,Arial",

"captionFontSize"=> "14",

"subcaptionFontSize"=> "14",

"subcaptionFontBold"=> "0",

"showborder"=> "0",

"paletteColors"=> "#EED17F,#97CBE7,#074868,#B0D67A,#2C560A,#DD9D82",

"bgcolor"=> "#FFFFFF",

"showalternatehgridcolor"=> "0",

"showplotborder"=> "0",

"labeldisplay"=> "WRAP",

"divlinecolor"=> "#CCCCCC",

"showcanvasborder"=> "0",

"linethickness"=> "3",

"plotfillalpha"=> "100",

"plotgradientcolor"=> "",

"numVisiblePlot"=> "12",

"divlineAlpha"=> "100",

"divlineColor"=> "#999999",

"divlineThickness"=> "1",

"divLineDashed"=> "1",

"divLineDashLen"=> "1",

"divLineGapLen"=> "1",

"scrollheight"=> "10",

"flatScrollBars"=> "1",

"scrollShowButtons"=> "0",

"scrollColor"=> "#cccccc",

"showHoverEffect"=> "1"

)

);

$arrData["data"] = array();

 

while($cRow = mysql_fetch_array($chartResult)) {

array_push($arrData["data"], array(

"label" => $cRow['ProgramNumber'],

"value" => $cRow['SUMTotalAmount'],

"link" => "programreport.php?t=Donor"

)

);

}

 

$jsonEncodedData = json_encode($arrData);

 

$columnChart = new FusionCharts("scrollcolumn2d", "TotalPoundsbyProgramChart" , 800, 300, "TotalPoundsbyProgram", "json", $jsonEncodedData);

 

$columnChart->render();

 

echo("<tr><td><div id='TotalPoundsbyProgram' align='center'><!-- Fusion Charts will render here--></div></td></tr>");

[Moonmi Sonowal]

Hi,

 

Please check out the explanation and sample provide in this tutorial 

 

http://www.fusioncharts.com/tutorials/php-mysql-charts/

 

Let me know if it is of any help.

 

Thanks.