This can be done with simple WHERE clauses in SQL. If you want for a specific date, you would query where a date is on a specific day. Using BETWEEN syntax tends to make it a lot easier, ie:
WHERE mydatefield BETWEEN ('2012-08-14', '2012-08-21').
PHP wise you just need to allow the user to input the date range.