Over the last several months I have been trying my best to learn to integrate Flash, MySQL and PHP to create a dynamic schedule page.
You can check out the schedule page by going here and clicking on “schedule”.
So far I have a form that allows me to submit data into the database. I have another script that grabs the information from my database and prints it out for reading in flash.
My MySQL database structure is like this:
Schedule (database)
january (table)
date (column) - smallint
venue (column) - varchar 25
time (column) - varchar 8
place (column) - varchar 25
extra (column) - varchar 33
I have a table for each month.
For serveral weeks I have scoured the internet looking for some information on how I could update the database via a form.
Basically I need to know first of all if I have my database set up the best way the schedule page.
Second of all I need to know the best way of editing the database via forms.
Any ideas, comments or code snippets would be of great help.
Also, if there are any prescriped PHP applications that allow adding, modifying and deleting that I could download and take a look at the source, that would be awesome.
Thanks,
DigitalMac
