<form action="<?php $_SERVER['PHP_SELF']; ?>" method="post" name="input">
<table>
<tr>
        <td>
<p> Username: </p>
        </td>
        <td>
        <input type="text" name="usradd">
        </td>
    </tr>
    <tr>
        <td>
<tr>
        <td>
<p> Password: </p>
        </td>
        <td>
        <input type="password" name="pwdadd">
        </td>
    </tr>
    <tr>
        <td>
<tr>
        <td>
<p> First Name: </p>
        </td>
        <td>
        <input type="text" name="nameadd">
        </td>
    </tr>
    <tr>
        <td>
<tr>
        <td>
<p> Last Name: </p>
        </td>
        <td>
        <input type="text" name="lastnameadd">
        </td>
    </tr>
    <tr>
        <td>
<tr>
        <td>
        <input type="hidden" name="submitted" value="TRUE">
        </td>
        <td>
        <input type="submit" value="Register" name="submitted">
        </td>
    </tr>
</table>
</form>
<?php
$con = mysql_connect("localhost","27481","password123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("27481", $con);


if ($_REQUEST['submitted'] == TRUE) {
    $usradd = $_REQUEST['usradd'];
    $pwdadd = md5($_REQUEST['pwdadd']);
    $nameadd = $_REQUEST['nameadd'];
    $lastnameadd = $_REQUEST['lastnameadd'];
    $sql= mysql_query("SELECT * FROM members WHERE username='".$usradd."'");
    $res = mysql_fetch_array($sql);

    if ($res['username'] == '".$usradd."') {
        echo "<p class=\"fail\">This username is taken, please choose another.</p>";
    }

    else {
        $query = "INSERT INTO members (username, password, name, lastname) VALUES ('".$usradd."', '".$pwdadd."', '".$nameadd."', '".$lastnameadd."')";
        mysql_query($query);
    echo "<p class=\"win\">Registered successfully</p>";
    }}
?>
<p>Click <a href="/login">Here</a> to go back.</p>