Date select form

[tbuzz]

I have a recordset showing on a page. One of the fields is a date field in the format yyyymmdd. I want to filter the recordset by date range where the user uses 3 select boxes dd mm yyyy for start and end date. I'm a total newbie and it's driving me nuts can anyone give me any pointers or a link that will help

[coldwerturkey]

heres a drop down menu i did the other day, take from it what you can!

echo "<form method='POST' action=''>";
// month
$m = "<select name='month' />";
for ($i = 1; $i <= 12; $i++) {
	$i = (strlen($i) == 2) ? $i : '0'.$i;
	$s = ($i == date('m')) ? " selected='selected'" : null;
	$m .= "<option value='".date('m', mktime(0,0,0,$i,1,2008))."'{$s}>".date('M', mktime(0,0,0,$i,1,2008))."</option>";
}
$m .= "</select>";
// days
$d = "<select name='day' />";
for ($i = 1; $i <= 31; $i++) {
	$i = (strlen($i) == 2) ? $i : '0'.$i;
	$s = ($i == date('d')) ? " selected='selected'" : null;
	$d .= "<option value='".date('d', mktime(0,0,0,1,$i,2008))."'{$s}>".date('j', mktime(0,0,0,1,$i,2008))."</option>";
}
$d .= "</select>";
// year		
$y = "<select name='year' />";
for ($i = 2006; $i <= 2020; $i++) {
	$i = (strlen($i) == 2) ? $i : '0'.$i;
	$s = ($i == date('Y')) ? " selected='selected'" : null;
	$y .= "<option value='".date('Y', mktime(0,0,0,1,1,$i))."'{$s}>".date('Y', mktime(0,0,0,1,1,$i))."</option>";
}
$y .= "</select>";
// put together
$form = $m." ".$d." ".$y;
echo $form;
echo "</form>";

than something like

if (isset($_POST['month'])) {
	$date = intval($_POST['year'].$_POST['month'].$_POST['day']); //which is yyyymmdd
}

[NogDog]

Assuming we have 3 $POST values from the form, I usually do something like this to ensure we received a valid date:

$yr = (int)$_POST['year'];
$mo = (int)$_POST['month'];
$day = (int)$_POST['day']
if(checkdate($mo, $day, $yr) == false)
{
   // add error message to validation results, or whatever you want to do
   // for an invalid date.
}
else
{
   $dbDate = sprintf('%04d%02d%02d', $yr, $mo, $day); // yyyymmdd
}

[bradgrafelman]

And once you get a valid start and end date (say $start and $end for simplicity), you could do a SQL query like so:

$sql = "SELECT col1, col2, date_col FROM myTable WHERE date_col BETWEEN '$start' AND '$end'";