Untitled

<?
echo "<h1>Register</h1>";

$submit = $_POST['submit'];

//form data
$fullname = strip_tags($_POST['fullname']);
$username = strip_tags($_POST['username']);
$password = strip_tags($_POST['password']);
$repeatpassword = strip_tags($_POST['repeatpassword']);
$date = date("Y-m-d");

if($submit){
    if($fullname && $username && $password && $repeatpassword){

        if($password==$repeatpassword){
            if(strlen($username)>25||strlen($fullname)>25){
                echo "Name or username is too long.";
            }
            else{
                if(strlen($password)>25||strlen($password)<4){
                    echo "Password must be between 4 and 25 characters";
                }
                else{
                    $password = md5($password);
                    $repeatpassword = md5($repeatpassword);

                    $connect = mysql_connect("localhost","root","");
                    mysql_select_db("phplogin");

                    $queryreg = mysql_query("INSERY INTO users VALUE ('','$fullname','$username','$password','$date')");

                    die("Registration succesfull! <a href='index.php'>Click here</a> to login.");
            }
            }
        }
        else
            echo "Your passwords do not match.";
    }
    else
        echo "Please fill in ALL fields";
}

?>
<p>
<html>
<form action="register.php" method="post">
<table>
<tr>
<td>
Your name:
</td>
<td
<input type="text" name="fullname" value="<? echo $fullname; ?>">
</td>
</tr>
<tr>
<td>
Username:
</td>
<td>
<input type="text" name="username" value="<? echo $username; ?>">
</td>
</tr>
<tr>
<td>
Password:
</td>
<td>
<input type="password" name="password">
</td>
<tr>
<td>
Password again:
</td>
<td>
<input type="password" name="repeatpassword">
</td>
</tr>
</tr>
</table>
<p><input type="submit" name="submit" value="Register">
</html>