I tried to created select menu's to insert the date into my database. I can't reformat it so the databse recognises it, it keeps displaying 0000-00-00.
I've been on it for days now please help.
I have inserted some of the code if that helps.
$D_O_B = strip_tags(trim($expYear. "-".$D_O_B. "-".$expDay));
//$D_O_B = date("Y-m-d", $D_O_😎;
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());
}
?>
<html>
<head>
<title>Insert Member Details</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form method="post" name="Insert_Mem" action="<?php echo $editFormAction; ?>">
<table align="center">
<tr valign="baseline">
<td nowrap align="right">Date of Birth:</td>
<td><select name="D_O_B">
<option value="01">January</option>
<option value="02">February</option>
<option value="03">March</option>
<option value="04">April</option>
<option value="05">May</option>
<option value="06">June</option>
<option value="07">July</option>
<option value="08">August</option>
<option value="09">September</option>
<option value="10">October</option>
<option value="11">November</option>
<option value="12">December</option>
</select>
<select name="expDay">
<option value="01">1</option>
<option value="02">2</option>
<option value="03">3</option>
<option value="04">4</option>
<option value="05">5</option>
<option value="06">6</option>
<option value="07">7</option>
<option value="08">8</option>
<option value="09">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select name="expYear" >
<option selected></option>
<option>1995</option>
<option>1994</option>
<option>1993</option>
<option>1992</option>
<option>1991</option>
<option>1990</option>
<option>1989</option>
<option>1988</option>
<option>1987</option>
<option>1986</option>
<option>1985</option>
<option>1984</option>
<option>1983</option>
<option>1982</option>
<option>1981</option>
</select> </td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="Insert_Mem">
</form>
<p> </p>
</body>
</html>😕
