Competition Data Collection??

[matt blank]

Hi,

I would like to put a competition on my website, which is a simple question with three multiple choice answers. At the moment, I've set it up like a PHP contact mail form. However this is useless, because if I get 500 entries it's going to take ages to go through them all, not to mention clog up my inbox!

Is there a script, that when they submit their answer and details, it either goes into a database, or a flat file script that could be exported as something like an Excel document.

Any help would be much appreciated. I'm not brilliant with code...

Thanks in advance,
Matt

[boogyman]

you can do it either way, however I would suggest a database.

you would need to set up the database accordingly... mainly making sure that all the values you wish to store are in the data field, and maybe some meta data... like time that it was submitted? this can be discussed more, but I do not want to waste both of our time if you do not have access to a database... so do you have access to a database like MySQL?

[matt blank]

I have two MySQL databases...but I'm using both of them for other scripts.

So in short, no I don't. The competition only has to last a week as well, so a simple flat file will probably be sufficient. As I said if it could then export the data at the end, that would be a bonus!

Many thanks!
Matt

[alexjewell]

You're still going to have to go through each entry with a flat file. I suggest using a free MySQL service like:

http://www.freemysql.net/v2/

There are several others, but that one is one of the most popular.