我目前正在从数据库中提取数据以部署在我的HTML页面上。我目前使用这个:
$sql = "SELECT item, count FROM user_inventory WHERE identifier='".$steamhextoidfin."'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo "<b>" . $row["item"]. "</b> " . $row[""]. "<br>";
}
现在我想知道如果"计数"数据大于 0 (>0(,它怎么可能只输出"项目"数据
只需添加位置,您的代码将如下所示:
$sql = "SELECT item, count FROM user_inventory WHERE identifier='".$steamhextoidfin."' AND count > 0";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo "<b>" . $row["item"]. "</b> " . $row[""]. "<br>";
}
你可以这样做:
$sql = "SELECT item, count FROM user_inventory WHERE identifier='".$steamhextoidfin."' AND count > 0";
您也可以对结果应用条件 - 如下所示
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
if($row["count"] > 0){
echo "<b>" . $row["item"]. "</b> " . $row[""]. "<br>";
}
}
}