Here is my php that goes through and sends an email to the registrant and to myself.

<?php

// Simple Form Script
// Copyright (C) 2005  Eric Zhang
// This program is free software; you can redistribute it and/or
// modify it under the terms of the GNU General Public License
// as published by the Free Software Foundation; either version 2
// of the License, or (at your option) any later version.
//
// Please send bugs/questions to erkzh@yahoo.com.

//--------------------------Set these paramaters--------------------------


$subject = 'WMAW 2005 Form Submission';      // Subject of email sent to you.
$subject2 = 'WMAW 2005 Form - Registrant';   // Subject of email sent to registrant.
$emailadd = 'sydcomebak@aol.com';            // Your email address. This is where the form information will be sent.
$url = 'http://www.wmaw2005.com';            // Where to redirect after form is processed.
$req = '0';                                  // Makes all fields required. If set to '1' no field can not be empty. If set to '0' any or all fields can be empty.

// --------------------------Do not edit below this line--------------------------
$text = "Results from form:\n\n";       
$space = '  ';
$line = '
';
foreach ($_POST as $key => $value)
{
	if ($req == '1')
	{
		if ($value == '')
		{echo "$key is empty";die;}
	}
	$j = strlen($key);
		if ($j >= 35)
		{echo "Name of form element $key cannot be longer than 35 characters";die;}
	$j = 35 - $j;
		for ($i = 1; $i <= $j; $i++)
		{$space .= ' ';}
	$value = str_replace('\n', "$line", $value);
	$conc = "{$key}:$space{$value}$line";
	$text .= $conc;
	$space = '  ';
}
mail($emailadd, $subject,  $text, 'From: '.$emailadd.'');
mail($email,    $subject2, $text, 'From: Registrar@WMAW2005.com');
echo '<META HTTP-EQUIV=Refresh CONTENT="0; URL='.$url.'">';
?>

Rather than collecting all of these emails(200+) and entering the information into the DB by hand, I figure that it'd be much better to turn around and have the php do the work for me. Any suggestions on where to start?

Thanks!

-Dave in IL

Do you want it to submit to DB ??

pretty much!

Here's the reg page:

www.wmaw2005.com/2005/registration/reg.php

the txt version:

www.wmaw2005.com/2005/registration/reg.txt

So I'll have to have the DB table keep a running count of registrants, (reg_id) or something, store their last_name, first_name, email, and other various choices that they make in the form.

Thanks for the prompt response! My DB guy quit and we're supposed to open registration on the 15th!

-Dave in IL

i saw the Reg page.. can you gv me the structure of the dB hey PM Private here is my yahoo id php_guy_uche@yahoo.com