ช่วยดูโค้ดให้หน่อยว่าผิดตรงไหน เวลารันแล้วมันจะไม่คำนวณยอดสั่งซื้อให้ค่ะ

<table width=500 cellspacing=0 cellpadding=1 align="center" border="1" bgcolor=#FFFFFF>
<TR bgcolor=#FFCCFF height="30">
<TD width="500" align="center" class="font13b" colspan="5">รายงานสมาชิกแยกตามช่วงอายุ</TD> 	
</TR>
<tr bgcolor=#FFCCFF height="30">
<td width=200 align="center" class="font12b">ช่วงที่</td>
<td  width=200 align="center" class="font12b">ช่วงอายุระหว่าง</td>
<td width=200 align="center" class="font12b">จำนวนสมาชิก/คน</td>
<td width=200 align="center" class="font12b">ยอดสั้งซื้อ</td>
</tr>
<?
$p=0;
$sql1="SELECT
group_concat( NAMES ) AS age_range_names,
sum( age_count ) AS age_range_count,
if( age >=60, 'more than 60', if( age >=50, '50-59', if( age >=40, '40-49', if( age >=30, '30-39', if( age >=20, '20-29', 'less than 20' ) ))) ) AS age_range
FROM
(SELECT count( * ) AS age_count, group_concat( member_id ) AS NAMES, current_date, member_birthday,
year( current_date ) - year( member_birthday ) + if( date_format( current_date, '%m%d' ) > date_format( member_birthday, '%m%d' ) , 0, -1 ) AS age FROM member

GROUP BY year( current_date ) - year( member_birthday) + if( date_format( current_date, '%m%d' ) > date_format( member_birthday, '%m%d' ) , 0, -1 )
) AS user_ages
 
GROUP BY if( age >=40, 'C4', if( age >=30, 'C3', if( age >=20, 'C2', 'C1' ) ) )
";
$res = mysql_query($sql1 )or die(mysql_error());
$numr = mysql_num_rows($res);
//while($row = mysql_fetch_assoc($res)){
while(list($age_range_names, $age_range, $age_range_count)=mysql_fetch_array($res)){
 $p++;

 ?>
<tr height="30">
<a  href="report_memberold2.php?pcode=<?echo $age_range_names; ?>" target="_blank">	
<td width=200 align="center" class="font12b"><? echo $p;?></td>
<td  width=200 align="center" class="font12b"><? echo $age_range_count;?></td>
<td width=200 align="center" class="font12b"><? echo $age_range;  ?></td>
<td width=200 align="center" class="font12b">
		<? //คำนวณยอดสั้งซื้อสินค้า
		$id = explode(',',$age_range_names);
		$n = count($id);
		for($i=0; $i<$n; $i++){
 
		$strsql="SELECT orderproduct.order_value
		FROM orderproduct 
		WHERE orderproduct.member_id = '$id[$i]'";
		$r = mysql_query($strsql)or die(mysql_error());
		$num = mysql_num_rows($r);
		while ($result = mysql_fetch_array($r)) {
		$total=0;
		$total = $total+$result['order_value'];
		echo $total;

		}//while
		}//FOR
	?>
				
</td>
</a>
</tr>
<?		
	}//while
?>
</Table>