ahh, now you're asking the right questions :-p
Wel,l start with a simple form asking the user for info that you want..
name
email
..
more?
<html>
<body>
<?
if(!isset($_POST['submit']) && $_POST['submit'] == 'Sign up!') //if the form was not submitted show form
{
?>
<form method="post" action="<? echo $_SERVER['PHP_SELF']; ?>">
Name: <input type="text" name="name" /><br />
Email: <input type="text" name="email" /> <br />
<input type="submit" name="submit" value="Sign up!" />
</form>
<?
}
else // if it was submitted
{
$name = $_POST['name'];
$email = $_POST['email'];
include("dbconnect.php"); //in this file you should have your db connection
$query = mysql_query("INSERT INTO table VALUES ('$name', '$email')") or die("Error adding info: " . mysql_error());
}
?>
mailing is another story..
but it will consist of selecting all from the database, and running it through a loop to mail each person
