Ok, I created a new little form in my footer (you can see it here: http://74.52.161.178/~gridiron/index.php) where people can sign up to receive emails/newsletters. I am not requiring them to be customers to join so, I will be managing two list basically.

What I would like to do it create a new table in my store database to store their name, email address and format they wish to receive. I am fine with creating the table, but I am not sure how to write the php code to insert the data into the table and throw an alert that the address was sucessfully added.

So, can someone tell how I would take the data from the form I've designed and enter the values into a new table? Once the record has been inserted an alert window can come up saying thanks for signing up and one they click ok they can stay on the page they are on.

Thanks so much.

PS: If you have any hints on validating that it is an email address would be cool too :)

Thanks