check if query was successful

[slava_php]

$qStr = "update user_info set user_password = 'aaabbb' where user_id = 'steve' and user_email ='[e-mail]' ";

$result = mysql_query($qStr, $connection) or die ("Error: " . mysql_error());

/*
how do I test if the qury was successful?

regardless of the existance of user_id and user_email entries, the mysql_query doesn't die.

and
if($result) is always true. i tried mysql_num_rows($result) and no value is returned.

the query does affect database when user_id and user_email are correct.

thanks in advance
*/

mysql_num_rows

[ahundiak]

Use mysql_affected_rows()