ปัญหาการเพิ่มข้อมูล ลงในตาราง คือมันไม่ครบตามรายการ

<?
$sql="select * from tempdebt where Type_Bill='S'";
$result=mysql_db_query($dbname,$sql);
while($r=mysql_fetch_array($result))
{
	$idbill=$r[ID_Bill];
	$typebill=$r[Type_Bill];
	$qtybill=$r[Qty_Bill];
	
	$sql1="select * from saledetail  where ID_Sale='$idbill'";
	$result1=mysql_db_query($dbname,$sql1);
	while($r1=mysql_fetch_array($result1))
	{
		$idsale=$r1[ID_Sale];
		$idmem=$r1[ID_Mem];
		$qtymake=$r1[Qty_Sale];
		$idpro=$r1[ID_Pro];
		
		//echo "$idsale-$idmem<br>";
		
		$sql3="INSERT INTO debtdetail(ID_Bill,ID_Mem) VALUES('$idsale','$idmem')";
		mysql_db_query($dbname,$sql3);
	}
}
?>