its saying 1 record added but data base table empt.any solution for that?
<p>this is an redirect page for form.this form will allow user to choose there group and database will store data into tables of selected groups.<br>
 include'connection.php';</p>

<pre><code>   if (isset($_POST['member']))
    {
    if (intval($_POST['member']) === Staff)
    {

        $insert1=mysql_query("INSERT INTO tblstaff(ST_Fname,ST_Sname,ST_Gender) VALUES``
                            ('$_POST[firstname]','$_POST[surname]','$_POST[sex]')");
    }
    else if (intval($_POST['member']) === Tutor)
    {
        $insert2=mysql_query( "INSERT INTO tbltutor(Tutor_Fname,Tutor_Sname,Tutor_Gender) VALUES
                     ('$_POST[firstname]','$_POST[surname]','$_POST[sex]')");
    }
    else if (intval($_POST['member']) === Student)

    {
        $insert3= mysql_query("INSERT INTO tblstudent(STU_Fname,STU_Sname,STU_Gender) VALUES ('$_POST[firstname]','$_POST[surname]','$_POST[sex]')");
    }
    else
    {
        if (!mysql_query() === false)
                   {
                           die('Error: ' . mysql_error());
                     }
                     else
                               echo "1 record added";


    }
}
</code></pre>

<p>its saying 1 record added but its not adding any data into database.</p>
