我尝试在 while 循环内运行多个查询,但没有任何反应,没有显示错误,也没有显示成功。任何人都可以解释或帮助我解决这个问题吗?这是我的代码
<?php
include('config.php');
$sql = 'SELECT * FROM inventory_masuk_dummy';
$query = mysqli_query($conn, $sql);
while($row = mysqli_fetch_array($query)) {
$jumlah = $row['jml'];
$size = $row['size'];
$nama_barang = $row['nama_barang'];
$status = $row['status'];
$sql2 = "UPDATE inventory_dummy SET jumlah = jumlah+$jumlah WHERE nama_barang = '$nama_barang' AND size = '$size'";
$sql3 = "UPDATE inventory_masuk_dummy SET status = '2' WHERE status='1'";
while($row = mysqli_fetch_array($sql2) && $row = mysqli_fetch_array($sql3)) {
echo "Berhasil di ubah, anda akan segera dialihkan";
}
}
echo "Nothing...";
?>
沧海一幻觉