Re: Database talk.

[LauraMoraiti]

Let’s say I create a small landing site with three fields:

-Name
-E-mail
-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),
– name,
– e-mail,
– newsletter or not and
– the date when this data was submitted.

This is the simplest case ever, but I hope you got my point