Untitled

<html>
<body>

<?php
if(!empty($_POST['uname']) && !empty($_POST['pass']))
{
$server = "localhost";
$user = "fiacoil_guyt";
$pass = "notforyoumister";
$database = "fiacoil_learning";


$connection = mysql_connect($server, $user, $pass)
or die("U FAIL");

        $user = "guyt";‫//‬mysql_real_escape_string($_POST["uname"]);
        $pass = mysql_real_escape_string($_POST["pass"]);
        $fname = mysql_real_escape_string($_POST["fname"]);
        $lname = mysql_real_escape_string($_POST["lname"]);

         $checkusername = mysql_query("SELECT * FROM users WHERE uname = '".$user."'");
        if(mysql_num_rows($checkusername) == 1)
            echo "Error, Username already taken.";
        else
        {
        $query = "INSERT INTO users (uname, pass, fname, lname) VALUES ('$user', '$pass', '$fname', '$lname')";
        mysql_select_db($database,$connection);
        mysql_query($query);
        mysql_close();
        }
}


?>

<form method="post" action="signup.php">
Username: <input type="text" name="uname"/></br>
Pass: <input type="password" name="pass"/></br>
First Name: <input type="text" name="fname"/></br>
Last Name: <input type="text" name="lname"/></br>
<input type="submit"/>
</form>

</body>
</html>