ผมต้องการให้ จำนวนของ amount – pro_amount แล้ว update amount แบบวนครับ พี่ ๆ ช่วยแนะนำหน่อยครับมีวิธี

$queryu = sprintf('select * from orders_tmp');
$resultu = mysqli_query($con,$queryu);
$rsu = mysqli_fetch_all($resultu);

$queryu1 = sprintf('select * from orders where pro_no="'.$rsu['pro_no'].'"');
$resultu1 = mysqli_query($con,$queryu1);
$rsu1 = mysqli_fetch_all($resultu1);


$totals = $rsu['pro_amount'] - $rsu1['amount'];

while($i<=$totals){
$queryu2 = sprintf(
		'update orders_tmp set pro_amount="%s" where pro_no="'.$rsu['pro_no'].'"',
		$totals);
                $resultu2 = mysqli_query($con,$queryu2);
                $i++;
}    
}