I’m trying to follow a login tutorial but I keep getting an error. The error I get is:
[code=php] Notice: Undefined index: id in c:inetpubwwwrootLoginregister.php on line 10
Notice: Undefined index: code in c:inetpubwwwrootLoginregister.php on line 11
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:inetpubwwwrootLoginregister.php on line 16
Your account could not be activated!
And my php is:
[code=php]<?
/* Account activation script */
// Get database connection
$db = mysql_connect(“localhost”);
mysql_select_db(“login”);
// 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 />”;
include ‘login_form.html’;
}
?>