$strXML = ""; $strQuery = "SELECT WEEK(answers.answerdate) AS d, avg(answers.answervalue) AS avg_value, playerid FROM answers, calendar WHERE answers.answerdate AND answers.playerid = '$playerid' AND calendar.diaryflag = 1 GROUP BY d ASC"; $result = mysql_query($strQuery) or die(mysql_error()); while($ors = mysql_fetch_array($result)) { $strXML .= ""; } $strXML .= ""; echo renderChart("charts/Line.swf", "", $strXML, "FactorySum", 500, 350, false, false);