<?php
    //henter mysql information
    $host="xxx"; // Host name
    $username="xxx"; // Mysql username
    $password="xxx"; // Mysql password
    $db_name="xxx"; // Database name
    mysql_connect("$host", "$username", "$password")or die("cannot connect");
    mysql_select_db("$db_name")or die("cannot select DB");

    // Check connection
    if (mysqli_connect_errno())
      {
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
      }

    $var = $_SERVER['QUERY_STRING'];

    //Create query
    $data = mysql_query("SELECT * FROM users WHERE activationkey = '$var'") or die(mysql_error());
    $result = mysql_fetch_array( $data );

    $member = mysql_fetch_assoc($result);
    $sql=mysql_query("UPDATE users SET activationkey='', status='activated' WHERE id=".$result['id']."");
    $result=mysql_query($sql);
    echo "Congratulations! You are now the proud new member of website.com";

    mysql_close();
 ?>