I need to select multiple records from a MySQL DB based on one date value that I get from a form.
When I get the date from the form I need to get the values for that date and for the six days before that to display the full week's data.
Don't have much of an idea where to start but what I have to get one record is:
$result = mysql_query("SELECT * FROM hourly where date='$date'");
if (!$result) {
die("Query to show fields from table failed");
}
If anyone knows how I should go about getting the records for the previous six days I would be greatly appreciative.
Thanx in advance!
