如何从MySQL表中获取非空值数据

Question

<form action="" method="POST">   <?php  $que = $con->query("SELECT *
FROM ques");       while ($row=mysqli_fetch_array($que)){
          echo "Q.".$row['id'].":".$row['que']."<br>";    echo "<input type='radio'
name='".$row['id']."'value='".$row['ans']."'>".$row['ans']."<br>";
echo "<input type='radio'
name='".$row['id']."'value='".$row['op1']."'>".$row['op1']."<br>";
echo "<input type='radio'
name='".$row['id']."'value='".$row['op2']."'>".$row['op2']."<br>";
echo <input type='radio'
name='".$row['id']."'value='".$row['op3']."'>".$row['op3']."<br>";  }
    ?> <br> <input type="submit" name="sub" value="submit"> </form
> 

Answer 1

您需要

将 where 子句添加到查询中。

而不是：

SELECT * FROM ques

像这样：

SELECT * FROM ques
WHERE yourField is not null

将yourField更改为要检查的字段。