Dropdown select date range from mysql

horstuff

Hi. Does anyone know of a way to make date ranges of results print based on what the user selects? For example, I need to build a dropdown with today's date, today and tomorrow, next weekend (not 7 days from now but next weekend), this month, etc. The results of their selection would print on the page for them to see.

I also then need to enable the user to hard print those results on their local printer (another thing I have no idea how to do. Maybe best for another post). I appreciate any help at all. I'm not nearly as proficient as I would like to be with this stuff. Thanks.

LordShryku

Look at [man]strtotime[/man] or [man]mktime[/man] for your dates

<select name="dates">
   <option><?php echo date("m/d/Y"); //today ?></option>
   <option><?php echo date("m/d/Y",strtotime("tomorrow")); // tomorrow ?></option>
   <option><?php echo date("m/d/Y",strtotime("this saturday")); // this coming saturday ?></option>
   <option><?php echo date("m/d/Y",strtotime("next saturday")); // next saturday ?></option>
</select>
<?php
/* for ranges
 * example printing two weeks
 */
?>
<select name="range">
   <option><?php echo date("m/d/Y"); //today ?></option>
<?php
for($i=1;$i<14;$i++) {
?>
   <option><?php echo date("m/d/Y",mktime(0,0,0,date("m"),date("d")+$i,date("Y"))); ?></option>
<?php
}
?>
</select>

horstuff

Thanks, but I am still a bit confused. My date field is called showdate in the mysql database. The file extension for my page is .php, so I won't be using <? or ?> except only once, at the beginning and end of the page. I am using "print" to show the results on the page. I guess I am unable to decipher how to make your code work with my script. Sorry, and thanks in advance for any other help you may be able to offer.