显示保存在数据库中的所有用户名[重复]

Question

This question already has an answer here:

• php function not returning all results from a MySQL query in a foreach 4 answers
• Get ALL results from database with username 1 answer

So I was wondering how do I display all usernames currently saved in my DB?

What I currently have still only displays 1 username

thanks for any help.

<?php

 $con = new mysqli("blank", "blank", "blank", "blank");


$result = mysqli_query($con,"SELECT * FROM users WHERE user_id > '0'");
$row = mysqli_fetch_array($result);



echo $row['username'];
?>

</div>

Answer 1

$con = new mysqli("blank", "blank", "blank", "blank");

$result = mysqli_query($con,"SELECT * FROM users WHERE user_id > 0");
while ( $row = mysqli_fetch_assoc ( $result ) ) {
    echo $row [ 'username' ] ."<br />";
}

It's nothing more than looping over your result.