hi,
I am trying to send this form to a admin e-mail address. I have tried a few things, but nothing happens and I don't want to use one of them pre-made scripts that store the info on their site.
here is the code. any insight will be great
<link rel="stylesheet" href="/sports/hockey/html/leaguestyle.css">
<style type="text/css">
<!--
a { color: #990000; text-decoration: none}
a:hover { color: #990000; text-decoration: underline}
-->
</style>
<?php
if ($post == "yes") {
//THEN WE ARE ADDING A NEW RECORD SUBMITTED FROM THE FORM
//REPLACE THE FIELD CONTENTS SO THEY DON'T MESS UP YOUR QUERY
/*-- SECTION: 9994SQL --*/
$sql = "INSERT INTO players (
id,lname,fname,teamid,position,number,dob,pob,weight,height,info,salary,terms,b_color,fint,status,captain,shoots,email,photo,registered,requested
$addl_insert_crit ) VALUES ( '$id',
'$lname','$fname','$teamid','$position','$number','$dob','$pob','$weight','$height','$info','$salary','$terms','$b_color','$fint','$status','$captain','$shoots','$email','$photo','$registered','$requested'
$addl_insert_values )";
if ($sql_debug_mode==1) { echo "<BR>SQL: $sql<BR>"; }
$result = mysql_query($sql,db());
if ($result == 1) {
echo "Thank you $fname a $lname for signing yourself into the UFHL hockey League";
} else {
echo "Error inserting record (9994SQL)";
}
//***** END INSERT SQL *****
} //END IF POST = YES FOR ADDING NEW RECORDS
if (!$post) {
//THEN WE ARE ENTERING A NEW RECORD
//***** BEGIN ADD NEW FORM*****
/*-- SECTION: 9994FORM --*/
?>
<form method="post" action="<?php echo $thispage; ?>?proc=New&post=yes&<?php echo $pagevars; ?>">
<center>
<body topmargin='0' leftmargin='0' rightmargin='0' bottommargin='0'>
<div align='center'>
<table background='/images/images/signupbk.gif' width='640' height='560'>
<tr>
<td valign='top' align='center'>
<table border='0' width='340' cellspacing='0' cellpadding='0'>
<tr><td height='66'></td></tr>
<tr><td></td></tr>
<TR>
<TD>
</TD>
<TD>
<INPUT TYPE='HIDDEN' NAME='id' SIZE='20'>
</TD>
</TR>
<tr>
<td width='25' height='30'></td>
<td bgcolor='#dfdfdf' class='table_header'>First Name:</td>
<td bgcolor='#dfdfdf' class='table_text' colspan='2'>
<input class='table_text' type='fname' name='fname'">
</td>
</tr>
<tr>
<td width='25' height='30'></td>
<td class='table_header'>First Name Intial:</td>
<td class='table_text' colspan='2'>
<input class='table_text' type='fname' name='fint'>
</td>
</tr>
<tr>
<td width='25' height='30'></td>
<td class='table_header' bgcolor='#dfdfdf'>Last Name:</td>
<td class='table_text' bgcolor='#dfdfdf' colspan='2'>
<input class='table_text' type='lname' name='lname'>
</td>
</tr>
<TR><TD></TD>
<TD>
<INPUT TYPE='HIDDEN' NAME='teamid' SIZE='20'>
</TD>
</TR>
<tr>
<td width='25' height='30'></td>
<td class=table_header>Position:</td>
<td class='table_text'>
<select name='position' class='table_text' style='width:83%'>
<option value=' '></option>
<option value='G'>Goalie</option>
<option value='D'>Defense</option>
<option value='C'>Center</option>
<option value='LW'>Left Wing</option>
<option value='RW'>Right Wing</option>
</select>
</td>
</tr>
<tr>
<td width='25' height='30'></td>
<td class=table_header bgcolor='#dfdfdf'>Number:</td>
<td class='table_text' bgcolor='#dfdfdf'>
<input class='table_text' type=text name='number'>
</td>
</tr>
<tr>
<td width='25' height='30'></td>
<td class=table_header>Date of Birth:</td>
<td class='table_text'>
<input class='table_text' type=text name='dob'>
</td>
</tr>
<tr>
<td width='25' height='30'></td>
<td class=table_header bgcolor='#dfdfdf'>Place of Birth:</td>
<td class='table_text' bgcolor='#dfdfdf'>
<input class='table_text' type=text name='pob'>
</td>
</tr>
<tr>
<td width='25' height='30'></td>
<td class=table_header>Nationality:</td>
<td class='table_text'>
<select name='b_color' class='table_text' style='width:83%'>
<option value=' '></option>
<option value='can'>Canada</option>
<option value='usa'>USA</option>
<option value='rus'>Russia</option>
<option value='fin'>Finland</option>
<option value='swe'>Sweden</option>
<option value='ukr'>Ukraine</option>
<option value='chk'>Czech</option>
<option value='slo'>Slovakia</option>
<option value='ger'>Germany</option>
<option value='aus'>Austria</option>
<option value='swi'>Swiss</option>
</select>
</td>
</tr>
<tr>
<td width='25' height='30'></td>
<td class=table_header bgcolor='#dfdfdf'>Weight:</td>
<td class='table_text' bgcolor='#dfdfdf'>
<input class='table_text' type=text name='weight'>
</td>
</tr>
<tr>
<td width='25' height='30'></td>
<td class=table_header>Height:</td>
<td class='table_text'>
<input class='table_text' type=text name='height'>
</td>
</tr>
<tr>
<td width='25' height='30'></td>
<td class=table_header bgcolor='#dfdfdf'>Shoots:</td>
<td class='table_text' bgcolor='#dfdfdf'>
<select name='shoots' class='table_text' style='width:83%'>
<option value=' '></option>
<option value='C'>Left</option>
<option value='R'>Right</option>
</select>
</td>
</tr>
<tr>
<td width='25' height='30'></td>
<td class=table_header>E-Mail:</td>
<td class='table_text'>
<input class='table_text' type=text name='email'>
</td>
</tr>
<TR><TD></TD>
<TD>
<INPUT TYPE='HIDDEN' NAME='info' VALUE='82 Fourmer' SIZE='20'>
</TD></TR>
<TR><TD></TD>
<TD>
<INPUT TYPE='HIDDEN' NAME='salary' SIZE='20'>
</TD></TR>
<TR><TD></TD>
<TD>
<INPUT TYPE='HIDDEN' NAME='terms' SIZE='20'>
</TD></TR>
<TR><TD></TD>
<TD>
<INPUT TYPE='HIDDEN' NAME='status' VALUE='Rookie' SIZE='20'>
</TD></TR>
<TR><TD></TD>
<TD>
<INPUT TYPE='HIDDEN' NAME='captain' SIZE='20'>
</TD></TR>
<TR><TD></TD>
<TD>
<INPUT TYPE='HIDDEN' NAME='photo' SIZE='20'>
</TD></TR>
<TR><TD></TD>
<TD>
<INPUT TYPE='HIDDEN' NAME='registered' SIZE='20'>
</TD></TR>
<TR><TD></TD>
<TD>
<INPUT TYPE='HIDDEN' NAME='requested' VALUE='0' SIZE='20'>
</TD></TR>
<TR>
<TD>
</TD>
<TD>
<INPUT TYPE="SUBMIT" VALUE="Add Record" NAME="submit">
<INPUT TYPE="RESET" VALUE="Reset" NAME="reset">
<FORM METHOD="POST" ENCTYPE="text/plain" ACTION="mailto:example@example.com?subject=UFHL Player Signup">
</TD>
</TR>
</TABLE>
</CENTER>
<BR>
</FORM>
<?php
} //END if post=""
// THERE IS DB STUFF HERE
?>
