Where am I going wrong in my simple code??

[lcp03o]

I am using this query below and it is not printing any info on my web page. Can anyone see where I am going wrong?? Thanks

PS the login and password have been changed for this post.

<?PHP
$con = mysql_connect("supremeserver11.com","pcgamez_database","1554789");
mysql_select_db("pcgamez_database");
$query = "Select file_name, file_rating from pafiledb_files order by file_rating desc limit 0, 10";
$result = mysql_query($query) or die("Can't complete query ".mysql_error());
While( $row = mysql_fetch_array($result));
{
echo $row[file_name];
echo $row[file_rating];
echo "<br>";
}
?>

[tekky]

change mysql_fetch_array to mysql_fetch_assoc and you should be good, I would also recommend enclosing your array key names in 'single quotes' like $row['name']

[lcp03o]

Thanks for the input, I have made the changes but I am still getting nothing?? Any more ideas??

The web page is http://www.pcgamez.net/test.php

[tekky]

well if you arent getting your DIE() error, then I would have to say your query isnt returning anything....

test that by adding

echo mysql_num_rows($result) .'<br>';

after your query before the WHILE loop

[sidney]

its the semi colon after your while statement remove it