PHP Code takes only one row from MySQL

Question

I have made a little website and i want that it shows every users who have registered in Admin Panel. Problem is that it only shows one user even if 5 people have registered.

PHP:

<?php $query = mysql_query("SELECT * FROM users ORDER BY id DESC");

while ($rows = mysql_fetch_array($query)) {
$steamid = $rows['steamid'];
$tlink = $rows['tlink'];
$email = $rows['email'];
$twitter = $rows['twitter'];
$admin = $rows['admin'];
$name = $rows['name'];
$rank = $rows['rank'];
$avatar = $rows['avatar'];
$ban = $rows['ban'];
}

echo '<img src="'.$avatar.'"> <br> '.$name.' <br> '.$tlink.' ';

?>

So how i can make it that it takes every user not only one user?

Please stop using mysql_* functions. These extensions have been removed in PHP 7. Learn about prepared statements for PDO and MySQLi and consider using PDO, it's really pretty easy. — Jay Blanchard
– Jay Blanchard, Commented Apr 8, 2016 at 16:06

Community · Accepted Answer · 2017-05-23 11:59:49Z

1

The echo needs to be inside the loop:

<?php 

$query = mysql_query("SELECT * FROM users ORDER BY id DESC");

while ($rows = mysql_fetch_array($query)) {
    $steamid = $rows['steamid'];
    $tlink = $rows['tlink'];
    $email = $rows['email'];
    $twitter = $rows['twitter'];
    $admin = $rows['admin'];
    $name = $rows['name'];
    $rank = $rows['rank'];
    $avatar = $rows['avatar'];
    $ban = $rows['ban'];

    echo '<img src="'.$avatar.'"> <br> '.$name.' <br> '.$tlink.' ';
}

?>

Please stop using mysql_* functions. These extensions have been removed in PHP 7. Learn about prepared statements for PDO and MySQLi and consider using PDO, it's really pretty easy.

edited May 23, 2017 at 11:59

CommunityBot

11 silver badge

answered Apr 8, 2016 at 16:07

Jay Blanchard

34.5k17 gold badges82 silver badges130 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP Code takes only one row from MySQL

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related