addDataFromDatabase syntax help needed

addDataFromDatabase(resource $query_result, string $db_field_ChartData[, string $db_field_CategoryNames, string $strParam, string $link])

Adds chart data and category names from database. This function is specially designed for single-series charts, but can be used to provide chart values for a single dataset in multi-series/stacked/combination charts.

Parameters:

* $query_result = SQL query result to fetch dataset from database.
* $db_field_ChartData = database field that contains data values.
* $db_field_CategoryNames = database field that contains category names.(Optional for multi-serise/stacked/combination charts)
* $strParam = (Optional) delimiter separated attribute list for dataplots.
* $link = (Optional) Adds hyperlink feature to dataplots. This adds the link attribute to dataplots or elements.It can be a simple URL say, "http://www.google.com" or another page say, "Drill/Detailed.php" etc. For details on drill down and creating links using FusionCharts, please go through the section Drill Down Charts.

This parameter has a link place holder format that helps creating dynamic links. Anything placed between ## and ##
(for example, . FactoryID in "Detailed.php?FId=##FactoryID##") will be regarded as a field/column name in the SQL query result. Value from that column will dynamically replcae that place holder. Hence, for each dataplot in the chart the link values will be different.

For detailed exmaple on this feature, please refer to Creating Drilldown charts in "Using With PHP Class" section.

Example:

$strQuery = "select weekNames,revenue from Sales order by weekNames where CMonth=1";
$result = mysql_query($strQuery);
$FC->addDataFromDatabase($result, "revenue", weekNames");

//Store chart data values in 'total' column/field and category names in 'ResourceName'
$strQuery = "SELECT a.ResourceID, b.ResourceName, sum(a.Quantity) as total, b.Color FROM fus_freewill_giving a, fus_resource_master b WHERE a.ResourceId=b.ResourceId GROUP BY a.ResourceId,b.ResourceName";
$result = mysql_query($strQuery) or die(mysql_error());

//Pass the SQL Query result to the FusionCharts PHP Class function
//along with field/column names that are storing chart values and corresponding category names
//to set chart data from database
if ($result) {
$FC->addDataFromDatabase($result, "total", "ResourceName");
}

//Store chart data values in 'total' column/field and category names in 'ResourceName'
$strQuery = "SELECT a.ResourceID, b.ResourceName, sum(a.Quantity) AS total FROM fus_freewill_giving a, fus_resource_master b WHERE a.ResourceId=b.ResourceId GROUP BY a.ResourceId,b.ResourceName";
$result = mysql_query($strQuery) or die(mysql_error());
//Pass the SQL Query result to the FusionCharts PHP Class function
//along with field/column names that are storing chart values and corresponding category names
//to set chart data from database
if ($result) {
$FC->addDataFromDatabase($result, "total", "ResourceName");
}

//Store chart data values in 'total' column/field and category names and attributes in 'Resource'
$strQuery = "SELECT a.ResourceID, CONCAT(b.ResourceName, ';color=', b.Color, ';isSliced=', b.Sliced) AS Resource, sum(a.Quantity) AS total FROM fus_freewill_giving a, fus_resource_master b WHERE a.ResourceId=b.ResourceId GROUP BY a.ResourceId,b.ResourceName";
$result = mysql_query($strQuery) or die(mysql_error());
//Pass the SQL Query result to the FusionCharts PHP Class function
//along with field/column names that are storing chart values and corresponding category names
//to set chart data from database
if ($result) {
$FC->addDataFromDatabase($result, "total", "Resource");
}