Upload file for the next few weeks

[cumc]

Hi,
For our church website, we have our weekly leader questions available weekly. Basically here's what I need:
An admin page that tells us the next, say 10, Sunday's. Then we can upload the file to a directory on the website. It would be nice to upload the next 10 files for the next 10 weeks. That file name would go into a MySQL database. Then I need the main page (public page that everyone sees) that has this week's file download.
Can anyone give me some tips on how to go about this. I'm pretty good with PHP/MySQL.
Thanks!

[timbim]

I'd do that with a table with ID, link to file and release date. Query for the front page to select the highest date <= today to display.

Simple

[cumc]

However how would it know to put in the next, say 10, Saturdays in the database?
Thanks!

[djr33]

Can you please explain more about how well you know PHP and MySQL? For someone who knows both well, it should not be very difficult. But if you are having trouble, we need to know what part exactly.
And you should also think about how you want to enter this: it would probably be best to enter each Saturday separately and let the system organize them separately, though it might be a little more work than using a single format with 10 weeks in one entry.

Do you need to know how to use PHP and/or MySQL? Or do you need to know how you would organize a system like this? Or both?