I believe the following would work:
<form action="registration.php" method="post">
<table width="400" border="0" align="center">
<tr>
<td><label>Full Name: </label></td>
<td><input type="text" name="full_name" id="full_name" /></td>
</tr>
<tr>
<td><label>Email Address: </label>
</td>
<td><input type="text" name="email" id="email" /></td>
</tr>
<tr>
<td><label>Username:</label></td>
<td><input type="text" name="username" id="username" /></td>
</tr>
<tr>
<td><label>Password: </label> </td>
<td><input type="password" name="password" id="password" /></td>
</tr>
<tr>
<td><label>Secret Pin: </label> </td>
<td><input type="text" name="pinword" id="pinword" /></td>
</tr>
<tr>
<td><label>Would you like to receive a monthly Newsletter?</label></td>
<td><select name="newsletter" id="newsletter">
<option value="blank"></option>
<option value="yes">Yes</option>
<option value="no">No</option>
</select></td>
</tr>
<tr class="ctr">
<td colspan="2"><input name="submit" type="submit" id="submit" value="Register" /></td>
</tr>
</table>
</form>
and process it as follows:
$myusername = $_POST['username'];
$myemail = $_POST['email'];
$mypassword = $_POST['password'];
$full_name = $_POST['full_name'];
$username = $_POST['username'];
$password = sha1($_POST['password']);
$passphrase = sha1($_POST['passphrase']);
$email = sha1($_POST['email']);
$newsletter - $_POST['newsletter'];
$pinword - $_POST['pinword'];
$website = "http://www.jennifermccurley.org/login.html";
$to = $myemail;
$subject = "Registration Confirmation";
$headers = 'From: webmaster@jennifermccurley.org' . "\r\n";
$message = "Dear $full_name," . "\r\n";
$message .= 'Thank you for registering to use Mrs. McCurley\'s class portal.' . "\r\n";
$message .= "Username: '$myusername'" . "\r\n";
$message .= "password: '$mypassword'" . "\r\n";
$message .= 'Please use the username and password above to access the portal.' . "\r\n";
$message .= $website . "\r\n";
//echo $subject . "<br />";
//echo $headers . "<br />";
//echo $message . "<br />";
$checkuser = mysql_query("SELECT username FROM users WHERE username='$username'");
$username_exist = mysql_num_rows($checkuser);
if($username_exist > 0){
echo "The username you specified has already been taken. Please choose another one.";
unset($username);
include 'registration_form.html';
exit();
}
if($pinword <> "Tibet"){
echo "The Secret Pin you specified is incorrect, please try again!.";
unset($pinword);
include 'registration_form.html';
exit();
}
$query = "INSERT INTO users (full_name, username, password, email, newsletter)
VALUES('$full_name', '$username', '$password', '$email', '$newsletter')";
mysql_query($query) or die(mysql_error());
mysql_close();
echo "Hi, $full_name, you are now registered to access our website.";
echo "<br>";
echo "Your username and password will be sent to you at $email.";
mail($to, $subject, $message, $headers);
?>