<?php

include 'mysql_connect.php';

/* Name the variables */

foreach($_POST as $key => $value) {
   $$key = mysql_real_escape_string($value);
if(strlen($value) == 0) {
$missing_field = $key;
    echo "Field: \"$missing_field\" is blank";
    include'register_form.php';
break;
}
}

if($password != $confirm_password) {
    echo "Passwords did not match";
    include 'register_form.php';
    die();
}
else{
    return;
}

$hashedPass = md5($password);

/* Username check */
$sql_username_check = mysql_query("SELECT username FROM users WHERE username='$username'");

if ($username_check > 0){
    if($username_check > 0){
        echo "The username you choose in unavailible, please try again.<br />";
        unset($username);
        include 'register_form.php';
    }
    die();
 }

$sql = mysql_query("INSERT INTO users (first_name, email_address, username, password, signup_date)
        VALUES( '$username',  '$email_address', '$first_name', '$hashedpass', now())") or die (mysql_error());

if(!$sql){
    echo 'Something went wrong in creating your account, please contact the webmaster or try again later.';
} else {
    $userid = mysql_insert_id();

    $subject = "Activate your account.";
    $message = "Dear $first_name ($username),
    Thank you for registering at Websitename.

    Here is the information required to log into your account, remember, keep this private!
    Username: $username
    Password: $password

    Thanks!
    The Webmaster

    This is an automated response, please do not reply!";

    mail($email_address, $subject, $message, "From: <emailaddres@domain.com>\nX-Mailer: PHP/" . phpversion());
    echo 'Your membership information has been mailed to your email address!';
}

?>