Please Help!

[BrixyG]

I can reformat the date now but it still won't save in my database in mySQL. It only stores 0000-00-00.

I've been on it for a whole week.

I've included the select query, I'm thinking the problem lie's there but I just can't find it.

$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
$editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}

if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "Insert_Mem")) {

$TITLE = strip_tags(trim("$TITLE"));
$MEM_FNAME = strip_tags(trim("$MEM_FNAME"));
$MEM_LNAME = strip_tags(trim("$MEM_LNAME"));
$ADDRESS1 = strip_tags(trim("$ADDRESS1"));
$ADDRESS2 = strip_tags(trim("$ADDRESS2"));
$CITY = strip_tags(trim("$CITY"));
$POSTCODE = strip_tags(trim("$POSTCODE"));
$HOMETEL = strip_tags(trim("$HOMETEL"));
$MOBILETEL = strip_tags(trim("$MOBILETEL"));
$D_O_B = strtotime(strip_tags(trim($expYear."-".$D_O_B."-".$expDay)));
$D_O_B = date("Y-m-d", $D_O_😎;
$HEIGHT = strip_tags(trim("$HEIGHT"));
$CLOTHES_SIZE = strip_tags(trim("$CLOTHES_SIZE"));
$PIX = strip_tags(trim("$PIX"));
$POSITION = strip_tags(trim("$POSITION"));

$insertSQL = sprintf("INSERT INTO member (TITLE, MEM_FNAME, MEM_LNAME, ADDRESS1, ADDRESS2, CITY, POSTCODE, HOMETEL, MOBILETEL, D_O_B, HEIGHT, CLOTHES_SIZE, PIX, POSITION) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($HTTP_POST_VARS['TITLE'], "text"),
GetSQLValueString($HTTP_POST_VARS['MEM_FNAME'], "text"),
GetSQLValueString($HTTP_POST_VARS['MEM_LNAME'], "text"),
GetSQLValueString($HTTP_POST_VARS['ADDRESS1'], "text"),
GetSQLValueString($HTTP_POST_VARS['ADDRESS2'], "text"),
GetSQLValueString($HTTP_POST_VARS['CITY'], "text"),
GetSQLValueString($HTTP_POST_VARS['POSTCODE'], "text"),
GetSQLValueString($HTTP_POST_VARS['HOMETEL'], "text"),
GetSQLValueString($HTTP_POST_VARS['MOBILETEL'], "text"),
GetSQLValueString($HTTP_POST_VARS['D_O_B'], "date"),
GetSQLValueString($HTTP_POST_VARS['HEIGHT'], "text"),
GetSQLValueString($HTTP_POST_VARS['CLOTHES_SIZE'], "text"),
GetSQLValueString($HTTP_POST_VARS['PIX'], "text"),
GetSQLValueString($HTTP_POST_VARS['POSITION'], "text"));

echo  "The following member has been added to the members table:<br>
<ul>
	<li>Name: $TITLE $MEM_FNAME $MEM_LNAME
	<li>Address: $ADDRESS1 $ADDRESS2 $CITY $POSTCODE
	<li>Tel: $HOMETEL $MOBILETEL
	<li>Date of Birth: $D_O_B
	<li>Height: $HEIGHT
	<li>Clothes Size: $CLOTHES_SIZE
	<li>Picture: $PIX
	<li>Position: $POSITION \n";
echo "</ul>";
echo "<a href='insert_mem_details.php'>Add another member</a> \n";

mysql_select_db($database_BrixtonTopCats, $BrixtonTopCats);
$Result1 = mysql_query($insertSQL, $BrixtonTopCats) or die(mysql_error());
}
?>

[Sxooter]

A tuple of points: 1: use the code tags. Its a [ code ] without the extra spaces, and [ /code ] after. It color highlights and indents your code so we can read it without our brains hurting too much. Also, right after posting you may spot your own syntax errors with color highlighting, so it helps you as well as us.

2: MySQL very helpfully inserts the garbage date of 0000-00-00 into your database when you have an improperly formatted date string.

If you recompile mysql, you can change that behaviour so it chokes on bad dates like a good database should. RedHat RPMS are already compiled this way, as are many other packages.

3: Try printing out your SQL query right before you run it, then take a look at it. The error is usually easier to see AFTER the query's been built than WHILE it's being built.