<?php
 ##################################
 #       Registration Form        #
 ##################################
 if(isset($_POST['submit'])){
     $username = str_replace("''", "''", stripslashes($username));
     $firstname = str_replace("''", "''", stripslashes($firstname));
     $lastname = str_replace("''", "''", stripslashes($lastname));
     $password = md5($_POST['password']);

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

     if($username_exist > 0){
        $error_message = "That user name is already Taken!";
     };

     $query = "INSERT INTO users(username, firstname, lastname, email, password)
               VALUES('$username', '$firstname', '$lastname', '$email', '$password')";

     if(mysql_query($query))
     {
        require_once('views/header.php');
        require_once('reg_succ.php');
        require_once('views/footer.php');
        exit();
     }
     else
     {
        die(mysql_error());
        require_once('views/header.php');
        include('reg_failed.php');
        require_once('views/footer.php');
        exit();
     }
 }