e.g
From: to:
(input date) (input date)
Then within this range the next page will execute my sql syntax. At this moment i can't narrow down the results to the specified date. I'm using access database.
Thanks!
Moderator: General Moderators
Code: Select all
<SELECT NAME=FromDate>
<?php
for ($i=1;$i<=31;$i++)
echo '<OPTION '.(isset($_POST['FromDate'])?$_POST['FromDate']==$i?' SELECTED':'':'').'>'.$i.'</OPTION>';
?>
</SELECT>
<SELECT NAME=FromMonth>
<?php
$arrMonths=array("January","February","March","April","May","June","July","August","September","October","November","December");
for ($i=0;$i<count($arrMonths);$i++)
echo '<OPTION VALUE="'.($i+1).'" '.(isset($_POST['FromMonth'])?$_POST['FromMonth']==($i+1)?' SELECTED':'':'').'> '.$arrMonths[$i].'</OPTION>';
?>
</SELECT>
<SELECT NAME=FromYear>
<?php
for ($i=1950;$i<=1985;$i++)
echo '<OPTION '.(isset($_POST['FromYear'])?$_POST['FromYear']==$i?' SELECTED':'':'').'>'.$i.'</OPTION>';
?>
</SELECT>
<SELECT NAME=ToDate>
<?php
for ($i=1;$i<=31;$i++)
echo '<OPTION '.(isset($_POST['ToDate'])?$_POST['ToDate']==$i?' SELECTED':'':'').'>'.$i.'</OPTION>';
?>
</SELECT>
<SELECT NAME=ToMonth>
<?php
$arrMonths=array("January","February","March","April","May","June","July","August","September","October","November","December");
for ($i=0;$i<count($arrMonths);$i++)
echo '<OPTION VALUE="'.($i+1).'" '.(isset($_POST['ToMonth'])?$_POST['ToMonth']==($i+1)?' SELECTED':'':'').'> '.$arrMonths[$i].'</OPTION>';
?>
</SELECT>
<SELECT NAME=ToYear>
<?php
for ($i=1950;$i<=1985;$i++)
echo '<OPTION '.(isset($_POST['ToYear'])?$_POST['ToYear']==$i?' SELECTED':'':'').'>'.$i.'</OPTION>';
?>
</SELECT>