Errors retrieving SQL data in PHP

[Plain Flailing]

I'm trying to code a simple webring using PHP and MySQL, but the following chunk of code...

 

$con = mysql_connect($dbhost,$dbuser,$dbpass);
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db($dbname,$con);


$query = "SELECT id, name, url FROM webring_sites";
$result = mysql_query($query,$con);


while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
    $allSites[$row]['id'] = $row['id'];
    $allSites[$row]['name'] = $row['name'];
    $allSites[$row]['url'] = $row['url'];
}

mysql_free_result($result);

mysql_close($con);

 

...is giving me these errors:

 

<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/home/####/public_html/webring/webring.php</b> on line <b>40</b><br />
<br />
<b>Warning</b>:  mysql_free_result(): supplied argument is not a valid MySQL result resource in <b>/home/####/public_html/webring/webring.php</b> on line <b>47</b><br />

 

I don't understand what the problem is with $result. Can anyone help me out?

[Barand]

Check for errors in query

$result = mysql_query($query,$con) or die(mysql_error());

[Plain Flailing]

Thanks Barand.

 

I'm almost too embarrassed to admit the cause of the problem, but just in case it helps another idiot searching the forum later: I'd simply forgotten to update a field name in my code after changing it in the database...  :-X