I have an html form to select two dates from dropdown. Now I need to retrieve all records from a MySQL database which lie between those dates. Can anyone help me?
+2
A:
Provided that $startDate and $endDate are in YYYY-MM-DD format (and $startDate is date before $endDate), you would probably need a query like :
$sql = "select field1, field2, ... from yourtable where yourdatefield between $startDate and $endDate";
wimvds
2010-08-16 12:51:49