我这里想要获取计数的值并保存到我的表格中,但是它没有起作用。我只想获取计数值,请你帮忙吗?我会感激任何回答。显示计数没有问题,但只是在保存到我的表格中出了问题。
<form method="POST">
Date : <input type="text" value="<?=$p_date?>" name="datereceived" />
<input type="submit" name="save" value="save">
</form>
PHP
<?
$sql="SELECT allinvty3.*, barcode.* , sample.*, count(barcode.itemcode) as icount
from barcode INNER JOIN sample on barcode.itemcode = sample.in_code INNER JOIN allinvty3 on
barcode.itemcode = allinvty3.in_code WHERE barcode.refnumber = '$temp'
GROUP BY barcode.itemcode";
$result = $conn->query($sql);
while($row = $result->fetch_assoc()) {
$icount = $row['icount'];
}
if(isset($_POST['save'])){
$sql = "UPDATE barcode SET datereceived ='$p_date', actualacount = '".$icount."', status='COMPLETE' WHERE status='PENDING'";
$conn->query($sql) ;
}
?>
actualacount ='$icount'
即可。 - GROVER.