why cant this be inserted

[vikela]

i have been trying to insert the following into mysql but no joy.the error i am getting is  string(0) ""

 

if($_SERVER['REQUEST_METHOD'] == "post") {
$month=$_POST['month'];
$day=$_POST['day'];
$year=$_POST['year'];
$dob = $year.'-'.$month.'-'.$day;
$gender = $_POST['gender'];
$race = $_POST['race'];
$segment = $_POST['segment'];
$region = $_POST['region'];

mysql_query("INSERT INTO PanelMember (date_of_birth, gender, race, segment, region) VALUES('$dob','$gender','$race','$segment','$region' ")or die(mysql_error());


echo "Member Added Inserted!..";
}

[mtoynbee]

No closing ) after region

 

 

[nadeemshafi9]

what is the mysql error ? do you have connection defined ? what is teh database table schema ?

[killah]

if($_SERVER['REQUEST_METHOD'] == "post") {
$month=$_POST['month'];
$day=$_POST['day'];
$year=$_POST['year'];
$dob = $year.'-'.$month.'-'.$day;
$gender = $_POST['gender'];
$race = $_POST['race'];
$segment = $_POST['segment'];
$region = $_POST['region'];

mysql_query("INSERT INTO PanelMember (date_of_birth, gender, race, segment, region) VALUES('$dob','$gender','$race','$segment','$region')")or die(mysql_error());


echo "Member Added Inserted!..";
}

[nadeemshafi9]

wth did you change anything ? i see it now one ) to close teh values