PHP database Insert not working
<p>Hey guys i have a problem basically i made a script in php which connects to a database. But when i try and send the data to the database it does not go into the data base even though it says thank you for signing up. But when i add the info and check to see if its in the database its not. Can someone please solve my problem thank you :)</p>

<pre><code>&lt;?php
$submitcheck = @$_POST['submit'];
$fullnameCheck = strtolower(strip_tags(@$_POST['fullname']));
$LastNameCheck = strtolower(strip_tags(@$_POST['Lastname']));
$UserNameCheck = strip_tags(@$_POST['username']);
$PasswordCheck = strip_tags(@$_POST['password']);
$ReCheckPass = strip_tags(@$_POST['repassword']);
$date = date("Y-m-d");

if ($submitcheck) {

    // connect to the database
    // checking data 

    if ($PasswordCheck &amp;&amp; $ReCheckPass &amp;&amp; $UserNameCheck &amp;&amp; $fullnameCheck &amp;&amp; $LastNameCheck) {


        if ($PasswordCheck == $ReCheckPass) {


            //Check length of username and password

            if (strlen($UserNameCheck) &gt; 25) {

                echo "Username must be less than 25 characters";
            } else {

                if (strlen($LastNameCheck) &gt; 25) {

                    echo "Last name must be less thank 25 charcters";
                } else {

                    if (strlen($fullnameCheck) &gt; 25) {

                        echo "Your Fisrt name is too long must be less than 25";
                    } else {

                        if (strlen($PasswordCheck) &gt; 25 || strlen($PasswordCheck) &lt; 6) {


                            echo "Password must be between 6 to 25";
                        } else {

                            //register the user 
                            $PasswordCheck = md5($PasswordCheck);
                            $ReCheckPass = md5($ReCheckPass);

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

                            $namecheckers = mysql_query("SELECT * FROM users WHERE username ='$UserNameCheck'");
                            $counts = mysql_num_rows($namecheckers);

                            if ($counts != 0) {

                                die("username in use sorry");
                            }

                            $queryreg = mysql_query("INSERT INTO users()id, username, password, FisrtName, LastName, date) VALUES ('id','$UserNameCheck','$PasswordCheck','$fullnameCheck','$LastNameCheck','$date')");

                            die("Congrats you have been registered &lt;a href='test.php'&gt;Click here&lt;/a&gt; to return to login page");
                        }
                    }
                }
            }
        }
        else
            echo "your passwords do not macth";
    }
    else
        echo "Please fill in all the information thank you ";
}
?&gt;


&lt;html


    &lt;head&gt;
    &lt;p&gt;
        &lt;meta http-equiv="Content-type" content="text/html; charset=utf-8"/&gt;
        &lt;title&gt;Register&lt;/title&gt;




    &lt;/head&gt;

&lt;body&gt;

    &lt;form action='register.php' method="POST" &gt;

        Fisrt Name: &lt;input type="text" name="fullname" value="&lt;?php echo $fullnameCheck; ?&gt;"/&gt;&lt;br /&gt;

        Last Name: &lt;input type="text" name="Lastname" value="&lt;?php echo $LastNameCheck; ?&gt;"/&gt;&lt;br /&gt;

        Chose Username: &lt;input type="text" name="username" value="&lt;?php echo $UserNameCheck; ?&gt;"/&gt;&lt;br /&gt;

        Chose Password: &lt;input type="password" name="password" /&gt;&lt;br /&gt;

        repeat Password: &lt;input type="password" name="repassword" /&gt;&lt;br /&gt;
        &lt;input type="submit" name ="submit" value="register"/&gt;

    &lt;/form&gt;



&lt;/body&gt;


&lt;/html&gt;
</code></pre>
