Checking for good update

[fbsd_user]

Using this code I get this error message.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL
result resource in /usr/local/www/data/mls_verifyemail.php on line
49

What code should I use to check if the update worked or not?


$query = "UPDATE members SET email_verified='X' WHERE
logon_id='".$logonid."'";

$result = mysql_query($query) or die('Query couldn\'t
executed:'.mysql_error());

if (mysql_num_rows($result) == 1)
    {
         // the user id and password match,
         print("User id on db");
        }
        else
        {
         //$errorMessage = 'Sorry, wrong user id / password';
         print("Sorry, wrong user id / password");

        }


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]