选择和回显1-7中的行

Question

嗨，我一直在尝试理解selecting和echo的用法，但我不知道如何在代码中实现它，所以我希望有人能帮助我

我有这段代码，我首先想在循环中回显，列id是1-7 (这也是第1-7行)，我该怎么做呢?我知道这应该是一种方法：

SELECT * FROM
(
SELECT ROW_NUMBER() OVER(ORDER BY ID) NUM,
* FROM bangpakong
) 
WHERE NUM >0 AND NUM <7

但是，当我在代码中使用它时，上面的代码只是给了我一个语法错误。下面是代码，它不需要只挑选1-7之间的行

$sql = "SELECT * FROM bangpakong";
if($result = mysqli_query($link, $sql)){
if(mysqli_num_rows($result) > 0){
echo "<div class='boks'>";
    echo "<div id='courseC'>";
echo "<img src='http://pattayasports.org/calendar/wp-
content/uploads/2017/11/Bangpakong-2.jpg' />";
echo "<p class='pleft'>Contact: 038 500 500 - 081 761 4874</p>";
echo "</div>";
echo "<div id='Crate'>";



    echo "<div class='Cheader'>";
        echo "<div>";

            echo "<div>Day</div>";
            echo "<div>PSC GF</div>";
            echo "<div>Visitor GF</div>";
            echo "<div>Cart</div>";
            echo "<div>Caddy</div>";


        echo "</div>";
    while($row = mysqli_fetch_array($result)){
        echo "<div>";

            echo "<div>" . $row['day'] . "</div>";
            echo "<div>" . $row['cf'] . "</div>";
            echo "<div>" . $row['viscf'] . "</div>";
            echo "<div>" . $row['cart'] . "</div>";
            echo "<div>" . $row['caddy'] . "</div>";
            echo "<div>" . $row['note'] . "</div>";
        echo "</div>";
    }
    echo "</div>";
    echo "</div>";
    echo "</div>";
    // Free result set
    mysqli_free_result($result);
} else{
    echo "No records matching your query were found.";
}
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
// Close connection
mysqli_close($link);

Answer 1

除非您使用的是支持ROW_NUMBER分析函数的非常新版本的MySQL，否则您的查询不会在MySQL上运行。但是，如果您希望表中的前7条记录按ID列排序，我们可以使用LIMIT实现相同的效果：

SELECT *
FROM bangpakong
ORDER BY ID
LIMIT 7;