Let’s say I create a small landing site with three fields:
-Would you like our newsletter?
Entering these three and clicking the “Send” button they are immediately elegible for a raffle.
The best way to store this data, so all the personal information I need to contact the winner is available (and later add the e-mails to a newsletter database) is to… bam… create a table with 5 columns within my database.
The 5 columns would be:
– An autoincrement one with an ID (so the raffle is imparcial and I can choose one just picking a random number with PHP or other),
– newsletter or not and
– the date when this data was submitted.
This is the simplest case ever, but I hope you got my point