[Resolved] How can I use mysql_affected_rows()

minds_gifts

Hello,

Once the user activates his email by clicking on the link he receives in his in box, he gets this message.Your e-mail has been activated.You will receive the profile details soon.
Heres the code:

$statement="UPDATE $mytable SET activated='1' WHERE activated='".$HTTP_GET_VARS['id']."'";
echo "Your e-mail has been activated.You will receive the profile details soon";
$sql=mysql_query($statement) or die(mysql_error());

The link which the user receives in his e-mail would look like
http://inkaytown.f2o.org/project/activate.php?id=aacedfhgj
If i open a new browser and just type upto activate.php with out id, i still see that message.

Though my table gets updated only when the user click on the link but still I want to avoid this message.
So, how should i use mysql_affected_rows() here in my context?
Thanks

barand

$statement="UPDATE $mytable SET activated='1' WHERE activated='".$HTTP_GET_VARS['id']."'"; 
$sql=mysql_query($statement) or die(mysql_error());
if (mysql_affected_rows($sql) > 0) 
echo "Your e-mail has been activated.You will receive the profile details soon";

(Are u sure that shouldn't be

.... WHERE id ='".$HTTP_GET_VARS['id']."'";

or something similar?)

hth

minds_gifts

Barand,

Now, I dont see any message printed on the screen when the user has activated the email link.But, I see the column(activated) gets updated to 1 after the user clicks the link.

Any ideas??

Thanks

barand

My apologies :o , mysql_affected_rows() takes the connection as its agument, not the query result. Or it can be used without any any and default to last connection link, so :-

$statement="UPDATE $mytable SET activated='1' WHERE activated='".$HTTP_GET_VARS['id']."'";  

$sql=mysql_query($statement) or die(mysql_error()); 
if (mysql_affected_rows() > 0)  

echo "Your e-mail has been activated.You will receive the profile details soon";

minds_gifts

Thats the trick, thanks barand.