OK, i have built a client login and yet when i test it the activation doesn’t work. Heres the URL http://client.cyhite.com/login/join_form.php. Here’s the code for the activate page
<?
// Get database connection
include 'db.php';
// Create variables from URL.
$userid = $_REQUEST['id'];
$code = $_REQUEST['code'];
$sql = mysql_query("UPDATE users SET activated='1' WHERE userid='$userid' AND password='$code'");
$sql_doublecheck = mysql_query("SELECT * FROM users WHERE userid='$userid' AND password='$code' AND activated='1'");
$doublecheck = mysql_num_rows($sql_doublecheck);
if($doublecheck == 0){
echo "<strong><font color=red>Your account could not be activated!</font></strong>";
} elseif ($doublecheck > 0) {
echo "<strong>Your account has been activated!</strong> You may login below!<br />";
}
?>
I use the double check in all of my user management systems and so i dont think its that but, i could be rong, let me in on your thoughts.
Sorry if I miss posted in the client side section…
