PHP, MySQL ผลรวมมันไม่ออก จากการ while loop แก้ยังไงดี ด่วนมาก

  <?
echo "$_REQUEST[txtCustomerID2] <br>";
  $result2 = mysql_query("select *  from requisition_good where (requisition_good.date_1 between '$fDate' and '$lDate') and   date_1 !='0000-00-00'");
 while($row2=mysql_fetch_array($result2)) { 
 	
		//echo "$row2[regood_id]<br>";
 		//$cmd4="select * from re_good where  regood_id='$row2[regood_id]' and id_product = '$_REQUEST[txtCustomerID2]' ";
		//$query4=mysql_query($cmd4);
		//$num = mysql_num_rows($query4);
		// while($result4 =mysql_fetch_array($query4)){
		//	 $i++;
		//echo "$i=$row2[number_1]=&nbsp;$result4[total]<br>";
		//echo  "<input type=text name=name2$i value=$result4[total]><br>";
		// }

 } //echo $result4;	
		$sum_query2 = "SELECT SUM(total) AS total FROM re_good WHERE id_product = '$_REQUEST[txtCustomerID2]' and regood_id='$row2[regood_id]'";
		$q2= mysql_query($sum_query2);
		$r2=mysql_fetch_array($q2);
		echo $aa=$r2[total];

 ?>