Suggestion for a web-based lesson tracking db

First of all I want to thank anyone who replies for the time and ideas.

I run a website at www.thruthebible.net which legitimately archives about 5000 mp3 files. I'd like to create a very simple database that will enable visitors to keep track of the lessons they've completed (listened to).

I have just enough database knowledge to hurt myself. I've worked with Visual Basic, MS Access & FrontPage. I've worked very little with mySQL and I can cut-n-paste Perl and PHP scripts. hehe Sorry, that's about it.

Here's what my puny experience in database development came up with:

Table "Lesson" having fields "ID", "Lesson Title", and "Duration". I have all this data already. (see www.thruthebible.net/book2.txt) The field ID is 5 digits (the first two digits are the book number (00 for Guidelines, 01 for Genesis, all the way to 66 for Revelation) and the last three digits are the file number in sequence 001 to whatever.)

Table "Users" having fields "Email" (unique identifier), "Password", "LessonCompleted" and "LessonCompletedDate".

That's about as far as I've gotten. I wanted to keep this very simple. Create an account by typing in your email address and a password. A reminder would be emailed to the user with their password. If they ever lose their password, they just enter their email address and it will be emailed to them. Once they authenticate, they would be taken to a screen which would have a table of the list of lessons they've completed. Somewhere on the page would be a databound listbox for them to choose a lesson to submit as a completed lesson. This would appear in the list of lessons completed table. There should also be an option to remove a completed lesson from the table of completed lessons.

Any help on where I should go from here would be greatly appreciated. What should I create the database with: MS Access, mySQL? Do I need any other tables other than the two I mentioned? How should I create the form to be able to have the functionality I want? I'd like to keep this very simple so that if I need to move to another host the application won't be a pain to move.

Thank you,
Gene Laratonda
gene@laratonda.net

I would use mySQL/PHP solution, you might consider changing hosts cause www.vizaweb.com can offer you a much better package.

Well, thanks for the quick answer. I guess I should expect that since you guys don't work for free. hehe

I didn't know PHP so I went to W3Schools.com and got a quick lesson on it. At the end I was able to make an ODBC connection to my MS Access database and list the lessons I mentioned earlier. Check it out at www.thruthebible.net/ALT/lessons.php. That's my first database connection using PHP. Earlier this evening I had no idea how to do that. Now for the arduous task of programming my application in a language I've not used before today other than cutting and pasting.

I never did get an answer on whether two tables would be enough to track what I want.

Vizaweb doesn't have a package for the amount of disk space I need. Nothing on their site about additional disk space. I need 15GB. What's wrong with the server I'm using now?