dates in a dropdown list

I was wondering if it’s possible to have a drop down list loaded with the last 15 or so days. I have a sheet where supervisors fill in the results of their visits. I had it so it would just date stamp it after the visit is over, but sometimes it happens a few days prior. I was hoping that php could come up with a list of the last 15 days and they could just select it. thanks

Read up on date intervals :slight_smile:

Thanks for the help. I’m afraid the tutorial is over my head though. Not a problem though.

I figured they can insert the date too (not as cool, but it would work). I’m running into issues. I’ve got the month, date and year coming from dropdown boxes. when I put everything together and echo the $visitDate, it works and prints it out nicely on the page. But inserting it into the database, it comes out as either -2015 (no month or date) when i use - sign or as a decimal number when I use the / sign. I’ve tried the data type as both varchar and text, but that didn’t make a difference either. I also tried double quotes vs single with no good results.

$visitDate=$_POST[month] . ‘/’ . $_POST[day] . ‘/’ . $_POST[year];

Can anyone see where I’m going wrong?

Sponsor our Newsletter | Privacy Policy | Terms of Service