FusionCharts Forum: Problem when getting data from Datasase - FusionCharts Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Problem when getting data from Datasase

#1 User is offline   kof20012 

  • Forum Newbie
  • Group: Members
  • Posts: 6
  • Joined: 21-August 10

Posted 21 August 2010 - 07:08 PM

hi everyone,

Im trying to creat a Column 2D chart where the data comes from database.
If the query only get 1 row the chart appears good, but if is more than 1 row the chart desapear and the place of the chart appear a message "Chart." what the problem?

im going to insert here the code(i dont think its here the problem...)

Quote


//Here is the database connection code

$strXML = ""; //sql query where it take 7 rows

$result = mysql_query($sql_contador);

if ($result) {
while($ors = mysql_fetch_array($result)) {
$strXML .= "< set name='".$ors['Alcunha']."' value='1' color='AFD8F8'" >; }
}
$strXML .= "
";

echo renderChart("FusionCharts/FCF_Column2D.swf", "", $strXML, "FactorySum", 1400, 450);
?>

Macieira

Tusófona - Real Tuna Lusófona
0

Other Replies To This Topic

#2 User is offline   Basundhara Ghosal 

  • Supreme Being
  • PipPipPipPipPipPipPipPip
  • Group: Members
  • Posts: 2459
  • Joined: 15-September 09

Posted 23 August 2010 - 08:39 AM

Hi,

Welcome to FusionCharts forum. :(

Please try checking if the chart is encountering any line-break while building the XML with the data from the database as in this case the FusionCharts.js file would encounter an error.

To check the same, please try using either FireBug(FF Browser) or the Developer Tool(IE Browser).

Hope this helps.

Regards,

Basundhara Ghosal

Follow us on Twitter :D
0

Other Replies To This Topic

#3 User is offline   kof20012 

  • Forum Newbie
  • Group: Members
  • Posts: 6
  • Joined: 21-August 10

Posted 23 August 2010 - 02:28 PM

Thanks a lot! :( It was a name that have the symbol ".
Macieira

Tusófona - Real Tuna Lusófona
0

Other Replies To This Topic

#4 User is offline   Basundhara Ghosal 

  • Supreme Being
  • PipPipPipPipPipPipPipPip
  • Group: Members
  • Posts: 2459
  • Joined: 15-September 09

Posted 23 August 2010 - 11:30 PM

Hi,

You are most welcome.

Glad that your issue is resolved.

Keep smiling and keep FusionCharting. :(

Regards,

Basundhara Ghosal

Follow us on Twitter :D
0

Other Replies To This Topic

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic