][aBo][
07-30-2004, 05:53 AM
This is just a basic question about php but I couldn't find anything using search.
I have the folllowing php scrpit that ads a person into a table.
$insert = "INSERT INTO mytable (number,name,tel,numberofpers,date)
VALUES ('','$name','$tel','$numberofpers','$date')";
The problem is that the first 4 variables add perfectly but there is no date while I'm sending "2004-09-29" through the form. The only date I get in the table is "0000-00-00".
I have the folllowing php scrpit that ads a person into a table.
$insert = "INSERT INTO mytable (number,name,tel,numberofpers,date)
VALUES ('','$name','$tel','$numberofpers','$date')";
The problem is that the first 4 variables add perfectly but there is no date while I'm sending "2004-09-29" through the form. The only date I get in the table is "0000-00-00".