Notice: Undefined index: 2aad888f2b4ac316b016a9a0bda1c329 on line 16
<p>Hello I am trying to make an email activation script in php and what you see above (2aad888f2b4ac316b016a9a0bda1c329) is this users unique activation key. What do you think the problem is?
Here is my NEW code:</p>

<pre><code>&lt;?php

$host="localhost"; 
$username="root"; 
$password="power1"; 
$db_name="members"; 
$tbl_name="users";

$link  = mysql_connect($host, $username, $password)or die("cannot connect. Please contact us");
mysql_select_db($db_name)or die("cannot select DB. Please contact us");

$queryString = $_SERVER['QUERY_STRING'];

if(isset($_SESSION[$queryString])) {
$query = "SELECT * FROM users WHERE email='$_SESSION[$queryString]'";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){
    if ($queryString == $row[activationkey]){
        echo "Congratulations! You have succesfully activated you account. You may now login.";

        $sql = ("UPDATE users SET activationkey='' AND status='activated' WHERE username=".$row['username']);

        if (!mysql_query($sql)) {
            die('Error: ' . mysql_error());
        }
    }
}
}


?&gt;
</code></pre>
