<?php
/*
#########################################
#              1337gamers               #
#                                       #
#                                       #
#                                       #
#########################################
*/

$dbhost = "localhost" //Default is localhost
$dbpass = "password" //Password
$dbuser = "root" //Default is root
$dbname = "dbname" //Name of the database

mysql_connect("$dbhost", "$dbuser", "$dbpass") or die("Couldn't connect:".mysql_error());
mysql_select_db("$dbname");

//Getting started with the script ;p
$username = $_POST['username'];
$password = md5($_POST['password']); //Passwords are now encrypted
$whyyouwanttobehere = $_POST['whyyouwanttobehere'];

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

if($user_exit > 0)
{
  echo "That username is already registered";
  unset($username);
  exit();
}

//exit(); will exit from the error checking and instert the results
$query = "INSERT INTO users(username, password, email, whyyouwanttobehere)VALUES('$username', '$password', '$email', '$whyyouwanttobehere')";
mysql_query($query) or die(mysql_error());
mysql_close();