<?php
include('config.php');
mysql_connect("$dbhost", "$dbuser") or die ("Could not connect: ".mysql_error());
mysql_select_db("$dbname") or die (mysql_error());

if(isset($_POST['submit'])) {
  $username = $_POST['username'];
  $email = $_POST['email'];
  $password = md5($_POST['password']); #Passwords are now MD5


$checkuser = mysql_query("SELECT username FROM users WHERE username = '$username'");

$user_exist = mysql_num_rows($checkuser);

if($user_exist > 0) {
  echo "That username is already registered according to our database records";
  include 'register.php';
  exit();
}

#Insert the username, password, and email
$query = sprintf(
    "INSERT INTO users(username, password, email) VALUES ('%s', '%s', '%s')",
    mysql_real_escape_string($_POST['username']),
    mysql_real_escape_string($_POST['password']),
    mysql_real_escape_string($_POST['email'])
);

mysql_query($query) or die (mysql_error());
mysql_close();
header('Location: index.php');
}
?>