任何人都可以在这个php / mysql UPDATE代码中发现错误 - mysql_affected_rows（）返回错误

Question

I have this PHP code:

The first look up query-1 works fine.. BUT The second query2 works as well but mysql_affected_rows() doesnt tell me if the record has been updated, why?

thanks.

---

$uemail  = '[e-mail]';
$authkey = '2f4071bffda44aa30064364055687d13';

require_once ('./domainsiteconnect.php'); // Connect to the database.

if ( $uemail && $authkey)
{

echo "<br>--uemail: [$uemail] -- && -- [$authkey] --- ";

$query1 = "SELECT * FROM member WHERE email='$uemail' AND actkey='$authkey' AND status='pending' ";

    $result1 = mysql_query ($query1);
    $num1 = mysql_num_rows ($result1);

    if ( $num1 == 1 )  // Exactly 1 rec found - Update member to verified.
    {
       echo '<br>+++ query1: successful +++>br>';

        $status = 'verified';

$query2 = " UPDATE member SET status='$status' WHERE email='$uemail'   ";    //AND actkey='$authkey'  ";
    //- $query2 = " UPDATE member SET status='$status' WHERE email='$uemail' AND actkey='$authkey'  ";

    $result2 = mysql_query($query2);
    $num2 = mysql_affected_rows($result2);


        if ( $num2  )  //  updated? - inform user
        {

            echo "<br>--$uemail updated to verified --";
        }
        else
            echo "<br>--$uemail  verfication [update] failed --";

            $val1=mysql_errno();
        $val2=mysql_error();

        //-- 
echo '<br>['.$query2.']--<br>--['.$result2.']<br>val-1:'.$val1.'<br> val-2'.$val2;


            }

    }   //-- eof. if auth/email flags ok ---

========================

The resulting output is:

 --uemail: [[e-mail]] -- && -- [2f4071bffda44aa30064364055687d13] ---

 +++ query1: successful +++>br>

 Warning: mysql_affected_rows() expects parameter 1 to be resource, boolean given in /home/arif/public_html/amy/public/domainsite/verifyfirst.php on line 125

 [e-mail] verfication [update] failed --
[ UPDATE member SET status='verified' WHERE email='[e-mail]'; ]--
--[1]
val-1:0
val-2

---

i think, the warning is because query2 doesnt return a resource-id that is needed by mysqL_affected_rows().

• both db and table are in utf8. what am i doing wrong ?

Answer 1

Indeed, put the result of mysql_connect in mysql_affected_rows to eliminate the error message and get the actual affected number of rows.