Can someone correct my simple code??

[lcp03o]

Hi, I can not see where I have gone wrong with my code?? I am new to this so if anyone can point out the mistake I will be very grateful!!!

<?PHP
$con = mysql_connect("myserver.com","username","mypassword");

$query = "";

$query = "Select file_name, file_rating from pafiledb_files order by filerating desc limit 0, 10";

$result = mysql_query($query);

While $row = msql_fetch_array($result)
{
echo $row[file_name];
echo $row[file_rating;
echo "<br>";
}
?>

[edit] removed username & password!!

[piersk]

Can you post the error message that you get please

[lcp03o]

I get this

Parse error: parse error, expecting `'('' in /home/www/pcgamez.net/test.php on line 10

[piersk]

And line 10 is which line?

Also, you don't need the line with

$query="";

oh and can you please edit your first post so that there is no username and password viewable.

[lcp03o]

It is this line

$result = mysql_query($query);

I have changed the password. Thanks

[leatherback]

Hi,

I think that is not the right line.

The while statement should have brackets, if I am correct.

While( $row = msql_fetch_array($result) )

J.

[lcp03o]

I have changed the "while" line but now I get this error

Parse error: parse error, expecting `']''

which points to this line - echo $row[file_name];

[leatherback]

No, it refers to the line after it.

echo $row[file_rating;

should of course be

echo $row[file_rating];

Please.. these are basic debugging things.. You could look a bit into the error and look at the line befoer / after th emessages..

J.