activatie probleem

			$activationcode = CreateKey();
			$password = md5($_POST[password]);
			$select = "SELECT * FROM members";
			$query = mysql_query($select);
			$count = mysql_num_rows($query);
			
			if($count == 0){
				$insert = "INSERT INTO leden (id, username, password, email, homepage, ip, activation, date, rank, subitle) 
						  			  VALUES ('', '" . $_POST['username'] . "', '" . $password . "', '" . $_POST[email] . "', '" . $_POST[homepage] . "', '" . $_SERVER[REMOTE_ADDR] . "', '" . $activationcode . "', NOW(), 'Beheerder', 'Beheerder')";
				$query = mysql_query($insert);
			}
			else {
				$insert = "INSERT INTO leden (id, username, password, email, homepage, ip, activation, date) 
									  VALUES ('', '" . $_POST['username'] . "', '" . $password . "', '" . $_POST[email] . "', '" . $_POST[homepage] . "', '" . $_SERVER[REMOTE_ADDR] . "', '" . $activationcode . "', NOW())";
				$query = mysql_query($insert);
			}

			echo "You are succesfully signed up, please activate your account with the activationcode we've just send to your email address";
			mail("$_POST['email']", "Aanmelding activeren", "Hi $_POST['username'],
		Thank you for your registration on $site_name. To complete your registration, please click the link below.
		
$site_url/?page=users/activate&code=$activationcode

If you have not registert, just ignore this email and the account will be deleted in 48 hours

$webmaster,
$site_url", "From: $site_name <$webmaster_email>\nReturn-path: $webmaster_email"); 

$activationcode = CreateKey();
			$password = md5($_POST[password]);
			$select = "SELECT * FROM members";
			$query = mysql_query($select);
			$count = mysql_num_rows($query);
 
			if($count == 0){
				$insert = "INSERT INTO leden (id, username, password, email, homepage, ip, activation, date, rank, subitle) 
						  			  VALUES ('', '" . $_POST['username'] . "', '" . $password . "', '" . $_POST[email] . "', '" . $_POST[homepage] . "', '" . $_SERVER[REMOTE_ADDR] . "', '" . $activationcode . "', NOW(), 'Beheerder', 'Beheerder')";
				$query = mysql_query($insert);
			}
			else {
				$insert = "INSERT INTO leden (id, username, password, email, homepage, ip, activation, date) 
									  VALUES ('', '" . $_POST['username'] . "', '" . $password . "', '" . $_POST[email] . "', '" . $_POST[homepage] . "', '" . $_SERVER[REMOTE_ADDR] . "', '" . $activationcode . "', NOW())";
				$query = mysql_query($insert);
			}
 
			echo "You are succesfully signed up, please activate your account with the activationcode we've just send to your email address";
			mail("$_POST['email']", "Aanmelding activeren", "Hi $_POST['username'],
		Thank you for your registration on $site_name. To complete your registration, please click the link below.
 
$site_url/?page=users/activate&code=$activationcode
 
If you have not registert, just ignore this email and the account will be deleted in 48 hours
 
$webmaster,
$site_url", "From: $site_name <$webmaster_email>\nReturn-path: $webmaster_email");

$select = "SELECT * FROM members WHERE activation='" . $_GET[code] . "' AND UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(date) < 48*60*60";

$query = mysql_query($select);
$exist = mysql_num_rows($query);
$list = mysql_fetch_array($query);

if($exist == 1 AND $list[activation] == $_GET[code] AND $list[activation] != 1){
mysql_query("UPDATE members SET activation = '1' WHERE activation = '" . $_GET[code] . "'");

	echo "Your account has been activated.";

}
else {
	echo "There was an error by activating your account<br /><br />";
	echo "- Your account has already been activated<br />";
	echo "- Your activation code is not correct<br />";
	echo "- You didn't activated within 48 hours<br />";
}
?>

$select = "SELECT * FROM members WHERE activation='" . $_GET[code] . "' AND UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(date) < 48*60*60";
 
$query = mysql_query($select);
$exist = mysql_num_rows($query);
$list = mysql_fetch_array($query);
 
if($exist == 1 AND $list[activation] == $_GET[code] AND $list[activation] != 1){
mysql_query("UPDATE members SET activation = '1' WHERE activation = '" . $_GET[code] . "'");
 
	echo "Your account has been activated.";
 
}
else {
	echo "There was an error by activating your account<br /><br />";
	echo "- Your account has already been activated<br />";
	echo "- Your activation code is not correct<br />";
	echo "- You didn't activated within 48 hours<br />";
}
?>