$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.
4
solved Display all usernames saved in database [duplicate]