Database Help

message from Lilywhite on 17 Jul 2004

I run a site for a non-league football team, and last season I ran a
Fantasy Football and Prediction League competition. This involved a
page on my site that was a form and the info was then emailed to me.
This worked very well but involved me typing the info into an Excel
spreadsheet. I was thinking of some form of database where once the
info was typed in on my webpage it would automatically enter the
database and save a lot of time. I am asking for help/advice regarding
this. Would I still be able to use an Excel spreadsheet to record data
or is MySQL a better option. Advice / ideas please.

Michael Fesser replied to Lilywhite on 17 Jul 2004

.oO(Lilywhite)

Not sure what to advise you, but it sounds like a database would be
really useful in this case. Of course the layout of the db depends on
the data you want to store in it.

Why to have an additional spreadsheet if the data is in the db already?
You can fetch whatever information you like from it, using simple SQL
queries (or a script that does it).

Micha

Archived message: Database Help (Macromedia Dreamweaver Web Design)