Problem with simple array

[lcp03o]

Can anyone see where I am going wrong?? With the following code I am gtting the error message

Call to undefined function: msql_fetch_array()

which points to the line $result = mysql_query($query);

<?PHP
$con = mysql_connect("Localhost","$database","$password");

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

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

[bastien]

While( $row = msql_fetch_array($result))

missing the 'y' in mysql

change to

While( $row = mysql_fetch_array($result))

msql is a different database and the ini file has it commented out so that it is not available

hth

[lcp03o]

Well spotted, I now get the error message

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

Any ideas??

[bastien]

change to this

$result = mysql_query($query) or die("Can't complete query ".mysql_error());