Automated Daily Function

I need to set up a system where a person will enter some information into a database, corresponding to a city and a date. Then I would need to set up a cron job that would go off once a day, pull up the date of all the cities and then email out that corresponding information. My original idea for a table was:

| id | city | date | information |
————————————————-

1 Chicago 11-01-10 some information
2 Chicago 11-02-10 more information
3 Seatle 11-01-10 information

So I figured that the cron job script would look up the date for that day, then execute emails with the information corresponding to that date.

Is this a good method or is there something more practical?

Also in #PHP _↴