Where am I going wrong??

[lcp03o]

Hi, I am using the following code to run a query, But I am getting the error message "Can't complete query No Database Selected" Any ideas???

<?PHP
$con = mysql_connect("supremeserver11.com","pcgamez_games","3162003");
$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]

my guess.... mysql_select_db()

[Tomz]

yep, my guess too. You're only connecting to the database and not selecting it.

use mysql_select_db(database_name_here);