Mysql affected rows

Question

I get an error ===> mysql_affected_rows() expects parameter 1 to be resource, boolean given in /var/www/mf/activate.php on line 23 when i execute the below code

$query_verify="UPDATE login SET status='active' WHERE username ='$username' AND actkey='$key'";  
      $result_verify=mysql_query($query_verify);
        if($result_verify)
          {
            $result= (mysql_affected_rows($result_verify)== ' 1 ');
            if($result)
    {
    echo "true";
   }
  else
   {
    echo "false";
   }

please help me to solve the problem query is executed but get this proble

Welcome to Stack Overflow! [Please, don't use `mysql_*` functions](http://stackoverflow.com/q/12859942/1190388) in new code. They are no longer maintained and are [officially deprecated](https://wiki.php.net/rfc/mysql_deprecation). Learn about prepared statements instead, and use [tag:PDO] or [tag:MySQLi]. — hjpotter92, Jun 21 '14 at 13:08

score 1 · Answer 1 · answered Jun 21 '14 at 13:07

1

Call mysql_affected_rows() without the parameter $result_verify.

answered Jun 21 '14 at 13:07

Jimmy T.

3,843
2
21
37

@raiserle but the parameter of mysql_affected_rows should be a resource. You either pass no parameter or the value returned by `mysql_connect`. – Jimmy T. Jun 21 '14 at 13:10
@Jimmy T. when $result_verify and some other query is executed at same time in database then how can i could know is it affected or not – user3756772 Jun 21 '14 at 13:13
if it is executed by many users at a time it changes – user3756772 Jun 21 '14 at 13:17
@user3756772 That does not matter unless both querys are executed in the same request. The function `mysql_affected_rows` distinguishes between diffrent connection. – Jimmy T. Jun 21 '14 at 13:21
thanks a lot it worked – user3756772 Jun 21 '14 at 13:31

Mysql affected rows

1 Answers1