Re: mysql_num_rows() <-- works but sometimes gives error?

pschwar@jhmi.edu writes: >When I use the function "mysql_num_rows()" it will work just fine except >that SOMETIMES I get this error message... > >Warning: Supplied argument is not a valid MySQL result resource in >/blahblah/patient/afterpassword.php on line 67 > >Here is the code... > >65 $query = "UPDATE users set password='$newpassword' WHERE username = >'$user'"; > 66 $result = mysql_query($query); >67 $num_results = mysql_num_rows($result); > this is just a guess, UPDATE queries does not return a result set and your mysql_num_rows counts all the rows in your result set. You should use mysql_affected_rows(). to check rows affected. >what am I doing wrong here?? > >Thanks!