Error question

[Anon]

Hi all,
Can anyone tell me where i am going wrong here. The error i am getting says:
PHP Warning: Supplied argument is not a valid MySQL result resource in /s101/home2/melbourne/trial1.php on line 6
My script is below:

<?
$link = mysql_connect('localhost', 'username', 'password');
mysql_select_db('melbourne');
$query = "SELECT * from Categories where CatParent IS NULL ORDER BY CatName";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)){
echo "<a href=\"http://trial2.php?id={$row['CatID']}\">{$row['CatName']}</a><br>\n";

}
?>

Any ideas?
Cheers,
micmac

[Anon]

Try printing out

print mysql_error();

to see what error happened.

Diego

[ziggs]

Hey I found your error. When it says line 6 just laugh at it. Your error is with line 3! You have the $link right? Then you wanna select a DB from that location right? You need something that does a little like mysql_select_db("melbourne",$link);
Why it says line 6 is because when it looks at this thing it knows it is looking at your select statement and gets confused because it doesn't know where your db named melbourne is. So it just says the last line it was on. I feel thats all.
Ziggs