请帮助我更正以下代码。
<?php
$sql = "SELECT SUM(quantity) from tblorders GROUP BY itemname" or die(mysql_error());
$query = $dbh->prepare($sql);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($query->rowCount() > 0) {
foreach($results as $result):
?>
<tr>
<td> <?php echo htmlentities($cnt);?></td>
<td><?php echo htmlentities($result->itemname);?></td>
<td><?php echo htmlentities ($result->quantity);?></td>
</tr>
<?php
$cnt++;
endforeach;
}?>
因为我无法按项目名称获取总和组。
尝试以下操作:
请注意,我已经为您修复了 sql。
<?php
$sql = "SELECT itemname, SUM(quantity) AS quantity from tblorders GROUP BY itemname";
$query = $dbh -> prepare($sql);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($query->rowCount() > 0) {
foreach($results as $result) { ?>
<tr>
<td> <?php echo htmlentities($cnt);?></td>
<td><?php echo htmlentities($result->itemname);?></td>
<td><?php echo htmlentities ($result->quantity);?></td>
</tr>
<?php
$cnt++;
}
}
?>
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)