Something

	$strXML = "<chart xAxisName='Week' showBorder='0' formatNumberScale='0' labelDisplay='WRAP'  decimals='2'  baseFont='Trebuchet MS'>";
	
	$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 .= "<set label='" . $ors['d'] . "' value='" . $ors['avg_value'] . "' />";
	}
	
$strXML .= "</chart>";
echo renderChart("charts/Line.swf", "", $strXML, "FactorySum", 500, 350, false, false);