MySQL fetch_assoc()显示少1个结果 [英] MySQL fetch_assoc() shows 1 less result

问题描述

我有一个如下表:

hub dep
A B
A C
B D
B E
B F
E G

我使用mysql select来获取查询，我的代码如下:

i use mysql select to get query and my code is like below:

$sql         = "SELECT dep FROM handd WHERE hub='B'";
        $result      = $conn->query( $sql );
        $row         = $result->fetch_assoc();

        while($row = $result->fetch_assoc()) {
    echo "id: " . $row["dep"]."<br>";
}

但是它给我的结果如下:

but it just gives me result like below:

id: E
id: F

我想知道D在哪里?

推荐答案

 $row         = $result->fetch_assoc();

此行存储"B D"的结果.实际上应该是:

This line stores the result of 'B D'. It actually should be:

    $sql         = "SELECT dep FROM handd WHERE hub='B'";
    $result      = $conn->query( $sql );

    while($row = $result->fetch_assoc()) {
        echo "id: " . $row["dep"]."<br>";
    }

这篇关于MySQL fetch_assoc()显示少1个结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！