Simple problem 4 beginner, please help.

[Anon]

Sorry, I am new to this game, can anyone tell me what ive done wrong.

Warning: Supplied argument is not a valid MySQL result resource in /home/gywebs99/public_html/gywebs/whatandwhere/pubs.php on line 53

Here is the code, with line 53 being 'print ("aregafgadfg");' which prints.

<?
$query = "SELECT * FROM tblPubGuide";
$result = mysql_db_query ('mydatabase', $query);
print ("aregafgadfg");
while ($row = mysql_fetch_array ($result)) 
{
	$pubname = $row["PubName"];
	$description = $row["Description"];				
	print ("$pubname");
	print ("$description");
}
?>

Cheers
Stu

[jacinthe]

before doing a query, you must connect to your database with that function :

resource mysql_connect ([string hostname [:port] [:/path/to/socket] [, string username [, string password]]])

check the manual at http://www.php.net/manual/en/function.mysql-connect.php

Jacinthe.

[Anon]

Well it looks like you aren't connected to your database. You should do tests to see if your database connection has been established.