mysql_affected_rows() problem

[tommmmm]

I'm using the following chunk of code to see if a user is activated and activate them if not etc. The mysql_affected_rows() is giving me problems. It is always 0 for some reason. The db values are updating, and if I run the same query (with valid username) in phpmyadmin then I get a results of 1.

$data = $_GET['username'];
$query = "UPDATE users SET activated='1' WHERE username='$data'";
mysql_query($query);
$result = @mysql_query ($query); 
//doesn't work affected_rows is always 0??
if (mysql_affected_rows() == 0) {
$q = "SELECT id FROM users WHERE username='$data' AND activated='1'";
if (mysql_num_rows(mysql_query($q))==0){
echo '<h1>Error!</h1><p>There has been an error processing your activation. Please re-try and if the problem persists then contact the administration.</p>';
}else{
echo '<h1>Error!</h1><p>Your username is already activated. Please go to the <a href="login.php">Login Page</a> to begin creating your profile.</p>';
}
}else{
echo '<h1>Thank you!</h1><p>You are now registered. Please head over to the <a href="login.php">Login Page</a> to begin creating your profile.</p>';
}

Thanks for the help

[esukf]

Read [URL=http:/www.php.net/manual/en/function.mysql-affected-rows.php#20910]this[/URL]

Particularly note this:

$query = "UPDATE ...";
mysql_query($query);
print mysql_affected_rows(); // more than 0
mysql_query($query); // same query twice
print mysql_affected_rows(); // 0.

.. this is because the 2nd time you execute the identical query, all the rows are already updated so no rows are affected the 2nd time.

I hope this clears up why mysql_num_rows() and mysql_affected_rows() are fundamentally different

[cheerio]

mysql_query($query);

should be

$query = mysql_query($query);