mysqli忽略表中的第一行 [英] mysqli ignoring the first row in a table

问题描述

这是我用来从表中提取数据的代码:

Here is the code I'm using to pull the data from the table:

require_once 'connect.php';
$sql = "SELECT * FROM `db-news`";
$result = $mysqli->query($sql);
$row = mysqli_fetch_assoc($result);
while ($row = $result->fetch_assoc()) {
    printf ($row['pagename'].' - To edit this page <a href="editnews.php?id='.$row['id'].'">click here</a><br>');
}

总是忽略第一行.我不会像在 SO 上的其他一些示例那样调用 mysqli_fetch_assoc 两次.我已经尝试在 while 循环中将 echo 更改为 printf 并且仍然忽略数据库中的第一行.

Always the first row is ignored. I'm not calling mysqli_fetch_assoc twice as with some other examples on SO. I've tried changing echo to printf in the while loop and still the first row is ignored in the DB.

我不知道接下来应该尝试什么?

I'm at a loss as to what I should try next?

推荐答案

mysqli 没有忽略它，但实际上你是在 while 循环之前获取第一行

mysqli not ignoring it but actually you are fetching first row before while loop

$row = mysqli_fetch_assoc($result); //remove this line
while ($row = $result->fetch_assoc()) {
   ....
}

这篇关于mysqli忽略表中的第一行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！