Register script function not inserting into database?!

[jarv]

here is my code:

function registerUser() {

   mysql_connect('localhost', 'user', 'password', 'table');
   $rsPostCode = $_POST['rsPostCode'];
    $rsGender = $_POST['rsGender'];
    $rsUser = $_POST['rsUser'];
   $rsPass = $_POST['rsPass'];
    $rsEmail = $_POST['rsEmail'];
    $rsMobile = $_POST['rsMobile'];
    $rsAge = $_POST['rsAge'];

   $sql = "INSERT INTO members_copy (rsPostCode, rsGender, rsUser, rsPass, rsEmail, rsMobile, rsAge) VALUES ($rsPostCode, $rsGender, $rsUser, $rsPass, $rsEmail, $rsMobile, $rsAge);";
//echo $sql;
   mysql_query($sql);
}

 

When I write out my SQL this is the output: INSERT INTO members_copy (rsPostCode, rsGender, rsUser, rsPass, rsEmail, rsMobile, rsAge) VALUES (BN11, Male, jarv, mypassword, john@email.com, 07998989999, 08/11/1978);

 

here is my register page: http://www.retroandvintage.co.uk/register.php

[PFMaBiSmAd]

Each string data value must be enclosed in single-quotes so that it will be treated as a string instead of an identifier or keyword.

 

You should also format and store the date of birth as a DATE data type so that it is easier to work with in any query.