php- echo not displaying from database

Question

I have a database in 'test' called 'leaderboard'... fields are 'id, name,g-b_ratio'

my code....

    <div class="leaderboard">
<?php
mysql_select_db("test")  or die("Cannot select the database");
$result = mysql_query("SELECT * FROM leaderboard") or die("Cannot select the database");
while($row = mysql_fetch_array($result)); 
{
echo $row['name']; } ?>

      </div>    

is not displaying anything from database.

why is it happening?

Answer 1

Do you realize there is a semicolon after your while() statement?

while($row = mysql_fetch_array($result)); 
{
echo $row['name']; }

I imagine it iterates to the last row before the echo is ever reached. Remove that semicolon and try again?