php - 使用 php 显示来自 mysql 表的数据

Question

出于某种原因，这个 php block 不断返回此错误，我不知道为什么；我在多种样式和范例中设置了相同的代码，但它一直返回错误

mysqli_fetch_assoc() expects parameter 1 to be mysqli_result

但是当我更改代码以使用 mysqli_result 函数时，php 说它未定义。

php block :

global $connection;
$query ="SELECT * FROM Members AND EXISTS (SELECT * FROM Lead);";
$result = mysqli_query($connection, $query);
$row = mysqli_fetch_assoc($result);

while($row){
  echo "<li>".$row['FIRST_NAME']."</li>";
}

Answer 1

1.在查询中用WHERE替换AND

2.将$row = mysqli_fetch_assoc($result);放入while()

像下面这样:-

global $connection;
$query ="SELECT * FROM Members WHERE EXISTS (SELECT * FROM Lead);";
$result = mysqli_query($connection, $query);
while($row = mysqli_fetch_assoc($result)){
  echo "<li>".$row['FIRST_NAME']."</li>";
}