<?php
$connection = mysql_connect("64.120.22.141", "1667_cj101" , "PASSWORD")
or die("ERROR: Couldnt connect to the database!");

mysql_select_db("1667_cj101") or die ("Couldnt select the database!");

$username = $_POST["username"];
$password = $_POST["password"];
$password2 = $_POST["password2"];

if($password != $password2 OR $username == "" OR $password == "")
    {
    echo "ERROR: Please fill in all fields!</a>";
    exit;
    }
$password = md5($password);

$result = mysql_query("SELECT Name FROM users WHERE Name LIKE '$username'");
$amount = mysql_num_rows($result);

if($amount == 0)
    {
    $entry = "INSERT INTO users (Name, password) VALUES ('$username', '$password')";
    $record = mysql_query($entry);

    if($record == true)
        {
        echo "Your Account has been created!</a>";
        }
    else
        {
        echo "ERROR: Couldnt create your account!</a>";
        }


    }

else
    {
    echo "Sorry, this Username is already taken.</a>";
    }
?>