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.