date conversions

[Jnoster]

I have spent a lot of time working on this issue. I have been through the forums. I am begining to believe that my problem may have to do with variable declarations. PHP is presenting the variable in one type (I'm thinking string) and mysql is looking for it in another. I have tried using the (int) declaration to no avail. What I am trying to do is create a form where the user enters a date. That date is sent to Mysql for later retrieval. The pertinent code follows...

<?php
$daterec = $HTTP_POST_VARS['daterec'];
$battype = $HTTP_POST_VARS['battype'];

list($day, $month, $year) = split('[/.-]', $daterec);
$date = $year.'-'.$month.'-'.$day;

$battype = addslashes($battype);

$battquery = "insert into batterytable (BATTnum, DateRcvd, BattType, Availability) values (".$newnum.", '".$date."', '".$battype."', 0)";

mysql_query($battquery);

OK... get all that? Everything works with this except the date. The table (DateRcvd) is a "DATE" datatype. When I check the content of the table from the command line editor it comes up as "0000-00-00" so the problem must be here. I have looked for syntax and found nothing. As far as I can tell my syntax is correct. I am left to believe the problem lies in the presentation of the variable to Mysql. Any ideas?

[devinemke]

rather than presenting a single form field for the date i suggest something like this:

<?php
$years = range(2005, 2015);
$months = range(1, 12);
$days = range(1, 31);

echo '
<form action="" method="POST">
year: <select name="year">
';	
foreach ($years as $value) {echo '<option>' . $value;}
echo '
</select>
<br>
month: <select name="month">
';
foreach ($months as $value) {echo '<option>' . $value;}
echo '
</select>
<br>
day: <select name="day">
';
foreach ($days as $value) {echo '<option>' . $value;}
echo '
</select>
<br>
<input type="submit" name="submit" value="submit">
</form>
';

if (isset($_POST['submit']))
{
	$date = date('Y-m-d', strtotime($_POST['year'] . '-' . $_POST['month'] . '-' . $_POST['day']));
	echo $date;
}
?>

[Jnoster]

Thanks for the suggestion. I will be studying it for all I can learn. However something in me is up to the challenge of understanding why what I am trying to do won't work and making what I want to have happen work... if that is a proper sentence...

Anyway... here is the form I am using...

	<form method="post" action="processregbatt.php" onSubmit="return checkform(this)">

		<tr width="100%">
			<td align="center" colspan="2">
				<br /><br /><h3>Register Battery.</h3>
			</td>
		</tr>
		<tr width="100%">
			<td align="right" width="50%">
				Date battery was recieved: 
			</td>
			<td>

<?php

$todaydate = date('n/j/Y');
echo '<input type="text" name="daterec" value="'.$todaydate.'">';

?>

			</td>
		</tr>
		<tr width="100%">
			<td align="right" width="50%">
				Battery type or model number: 
			</td>
			<td>
				<input type="text" name="battype">
			</td>
		</tr>
		<tr>
			<td colspan="2" align="center">
				<input type="submit" value="Register Battery">
			</td>
		</tr>

				</form>

[Jnoster]

So... any ideas?