Activation

[Daney11]

Hey guys,

 

Im using

 

if (isset($_GET['id'])) {
$id = (int) $_GET['id'];
} 
else {
$id = 0;
}

if (isset($_GET['member_code'])) {
$getmember_code = $_GET['member_code'];
} 
else {
$getmember_code = 0;
}

if (($id > 0) &&(strlen($getmember_code) == 32)) {

$UpdateStatus = "UPDATE members SET member_active = 'Yes' WHERE (member_id = $id AND member_active = '".escape_data($getmember_code)."') LIMIT 1";
$UpdateResult = mysql_query($UpdateStatus, $connect) or die(mysql_error());
if (mysql_affected_rows() == 1) {
echo "Yes";

} else {

echo "No";
echo $UpdateStatus;

}

mysql_close();

} else {

echo "SeeYa"; 

}

 

And it isnt working..... The result im getting is...

 

No

UPDATE members SET member_active = 'Yes' WHERE (member_id = 13 AND member_active = '574709b541e5382feeb6a39176a1f2b8') LIMIT 1

 

Which is correct. $connect is to connect to my database in settings.php included at the top....

 

I cannot figure out why it isnt Updating..

 

Any ideas?

 

Thanks

[Daney11]

sorted