require 'database.php';

   $password = $_POST['password'];
   $fname = $_POST['fname'];
   $lname = $_POST['lname'];
   $username = $_POST['username'];
   $email = $_POST['email'];

   $message = '';
   if ($password === ""){
       $message = "<div class='errormsg'>Oops! Must've missed a spot!</div>";
   }
   else if ($fname === ""){
       $message = "<div class='errormsg'>Oops! Must've missed a spot!</div>";
   }
   else if ($lname === ""){
       $message = "<div class='errormsg'>Oops! Must've missed a spot!</div>";
   }
   else if ($email === ""){
       $message = "<div class='errormsg'>Oops! Must've missed a spot!</div>";
   }
   else if ($username === ""){
       $message = "<div class='errormsg'>Oops! Must've missed a spot!</div>";
   }
   $query = mysql_query("SELECT username FROM users WHERE      username='".$username."'");

   if (mysql_num_rows($query) != 0)
   {
       $message = "<div class='errormsg'>Username already exists!</div>";
   }