this is my coding:
<?php
if(isset($_POST['add'])) {
$myServer = "localhost";
$myUser = "sa";
$myPass = "";
$myDB = "SCSMembers";
$conn = mssql_connect('localhost', 'sa', '');
$blnresult = mssql_select_db('[SCSMembers]', $conn);
$Name = $POST['Name'];
$Gender = $POST['Gender'];
$Marital = $POST['Marital'];
$Nric = $POST['Nric'];
$Nationality = $POST['Nationality'];
$Race = $POST['Race'];
$Email = $POST['Email'];
$Password = $POST['Password'];
$CPassword = $_POST['CPassword'];
$query = "INSERT INTO AR01_MEMBER_ACCOUNT (NRIC) VALUES ('$Nric')";
mssql_query($query);
}
?>
when i want to insert nric into my database, it doesn't work , i cannot insert it into my database. can you help me ?