mysql_fetch_object() error! HELP

[sstonge]

I am trying to access my MySQL database on windowsXP IIS5.

I get this error

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in c:...mytest.php on line 8

Here is the code I'm usging

<?php
mysql_connect('localhost', 'root');
mysql_select_db('cardguard');

$query = "SELECT issuer_name FROM cards WHERE card_id = 2";
$result = mysql_query($query);

while ($row = mysql_fetch_object($result)) {
echo "$rows->issuer_name<br>\n";
}

?>

thanks a tone

[ahundiak]

Always check for errors after a query.
$result = mysql_query($query);
if (mysql_errno()) die(mysql_error());

Your sql statement looks correct so you probably misspelt a column name. The error message should help pin it down.