I’m creating an application that will retrieve information from a MySQL database depending on the current date.
The table structure is someting like this:
ID DATE **LOCATION
**0 01/02/2007 London
1 02/02/2007 Paris
2 14/04/2007 Mexico
3 22/04/2007 Fiji
4 11/06/2007 Toronto
5 29/09/2007 Sydney
What I want to do is select the location by the current date, so the select statement would be something like:
“SELECT * WHERE date=‘02/02/2007’”;
From the table above this would select ‘Paris’ as the location. But as you can see, there is not a different location for every single day. Some locations remain the same for months.
So, my question is this:
I don’t want to have to enter the location for every single day of the next year into the database.
ie:
ID DATE LOCATION
1 02/02/2007 Paris
2 03/02/2007 Paris
3 04/02/2007 Paris
4 05/02/2007 Paris
5 06/02/2007 Paris
This would take far too long and waste resources. But how then, if the current date is not one that is specifically specified in the “date” column, could I select the location from the current date?
I hope this makes sense. Any help would be very much appreciated.
