# sorry my mistake UPDATE table should be UPDATE users
$query = mysql_query("UPDATE table SET unique_id='$_GET[id]',active=1 WHERE unique_id='$_GET[id]' AND active=0");
if(mysql_affected_rows()==1) {
// if (mysql_affected_rows($query)==1) {
print 'you are activated';
}
else
{
print 'you are already activated or you have not been sent activation';
}
<?php
mysql_connect($srv, $usr, $pwd) or die("Could not connect: " . mysql_error());
mysql_select_db($db);
$query = "UPDATE table SET unique_id='" . $_GET['id'] . "',active=1 WHERE unique_id='" . $_GET['id'] . "' AND active=0";
$result = mysql_query($query) or die("Could not query: " . mysql_error());
if (mysql_affected_rows($result) == 1)
print 'you are activated';
else
print 'you are already activated or you have not been sent activation';
?>