I've been doing some work for a friend. She owns a store where they often host classes for their customers to attend. She uses FrontPage to edit her site and was until recently simply listing all her class offerings as a long page of text. I recently changed that so now customers can access each month's calendar via drop down, and all classes offered appear as a link to a pop-up with the details about that class. Unfortunately I'm still pretty new at this and I can only do it in HTML. I have to create a new page for each class, then insert the hyperlink to the pop-up in the calendar table's html code. And while I've figured out how to allow customers to view and print a list of all the class titles, there's no way for them to access a complete, printable listing of all the class descriptions. They have to click on the link to the class they want, and if they want to print they have to print each class individually.
Here's a list of what I'd LIKE to be able to do:
Create a "Classes" database, which would hold the information about every class (date/time, Title, description, etc.).
Be able to add/edit a class in the database ONCE and have it update the schedule (either add it to a calendar view and/or update the calendar view).
Be able to click on a link for any given event to view a pop-up or something similar (and maybe less annoying to users!) that shows details about the event (description, etc).
Be able to view a complete list of all classes offered (sorted by date or alpha by title)
Be able to print a complete list of all class descriptions/details.
I contacted the company that hosts her page, and they said they CAN add a database (which would ideally streamline all of the above, and make things easier on me as well as all her customers). But they simply told me to go to www.hotscripts.com, and choose a PHP database and let them know which one I want. I know enough to do what I've done so far, but not enough to determine which would work best for this.
Can anyone recommend somethign that might work for what I want it to do??? Thanks in advance!
ps - I'm sorry if I sound like an idiot, but as I said I'm totally new to this and trying to learn...