please do this way,

$strQuery = "SELECT SUM(RAW_AMOUNT) as TotalRawAmount, SUM(FG_AMOUNT) as TotalFGAmount, SUM(WIP) as TotalWIPAmount, UPLOAD_DATE FROM raw_fg_sum GROUP by UPLOAD_DATE";

1) 1st create UPLOAD_DATE categories : convert this sql to recordset after fetch etch record and convert it to category

2) 2nd create date wise dataset of TotalRawAmount from recordset

3) 3rd create date wise dataset of TotalWIPAmount from recordset

see this ->

$strQuery = "SELECT SUM(RAW_AMOUNT) as TotalRawAmount, SUM(FG_AMOUNT) as TotalFGAmount, SUM(WIP) as TotalWIPAmount, UPLOAD_DATE FROM raw_fg_sum GROUP by UPLOAD_DATE";

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

$strXML="<graph>";
$Category="<categories>";
$DataRawAmount="<dataset seriesname='RawAmount' color='FF0000'>";
$DataFGAmount="<dataset seriesname='FGAmount' color='009900' showValues='1' >";
while($oRs=mysql_fetch_array($result)){
   $Category .= "<category name='" . $oRs['UPLOAD_DATE'] . "' />";
   $DataRawAmount .= "<set value='" . $oRs['TotalRawAmount'] . "' />";
   $DataFGAmount .= "<set value='" . $oRs['TotalFGAmount'] . "' />";
}
$Category .= "</categories>";
$DataRawAmount .= "</dataset>";
$DataFGAmount .= "</dataset>";

$strXML .= $Category . $DataRawAmount . $DataFGAmount . "</graph>";

i think it will work

Arindam Baral

Infosoft Global

Thanks,
Arindam

FusionCharts Team
www.fusioncharts.com