我确信我的表中有两行数据满足where子句的条件,但是我的代码只输出(回显)一行。我做错了什么?
<?php
$connect= mysqli_connect("localhost", "root", "", "friends_list")
or die('error connecting with the database');
$query= "SELECT * FROM people WHERE age=19";
$result= mysqli_query($connect, $query)
or die('error querying the database');
$row= mysqli_fetch_array($result);
while ($row = mysqli_fetch_array($result))
{
echo $row['first_name'] . " " . $row['last_name'] . " is " . $row['age'] . "<br/>"
}
mysqli_close($connect);
?>发布于 2012-03-18 17:17:56
您正在吞下第一行,并且没有对它做任何事情;例如,change:
$row= mysqli_fetch_array($result);
while ($row = mysqli_fetch_array($result))至:
while ($row = mysqli_fetch_array($result))发布于 2012-03-18 17:17:50
您正在获取第一行,但没有对它做任何操作,因此不会在while循环中获取此行,因此不会输出此行。
$row= mysqli_fetch_array($result); // remove this
while ($row = mysqli_fetch_array($result))
{
echo $row['first_name'] . " " . $row['last_name'] . " is " . $row['age'] . "<br/>"
}发布于 2012-03-18 17:19:11
在此部分中:
$row= mysqli_fetch_array($result);
while ($row = mysqli_fetch_array($result))
{您跳过了第一行。先获取它,然后在while循环中立即获取下一个。您应该删除第一个fetch,并且只有以下内容:
while ($row = mysqli_fetch_array($result))
{https://stackoverflow.com/questions/9757202
复制相似问题