// process form
//*****add_expense.php*****
//*****Script v. 1.0*****
//This page displays and handles a form for inserting records into expenses table.
//Include the MySQL information
require_once ("balfdfafadf.php");
if($submit) {
$result = mysql_query("INSERT INTO member_table (`l_name`, `f_name`, `m_name`, `street`, `city`, `state`, `zip`, `phone`, `email`) VALUES
('$l_name','$f_name','$m_name','$street','$city','$state','$zip','$phone','$email')");
echo "The record has been added.\n";
} else {
?>
<form method="post" name="theform" action="simplesubmit.php">
<TABLE border=0 cellPadding=0 width="100%">
<TBODY>
<TR bgColor=#8fbc8f>
<TD colSpan=3 align=center><B class="tdw"> WQI Online</B></TD>
</TR>
<TR bgColor=#0066cc>
<TD colSpan=3><B class="tdw"> <font color="#FFFFFF"><span class="tdb">MEMBER
INFORMATION </span></font></B></TD>
</TR>
<TR>
<TD width="24%" class="td">First Name:</TD>
<TD width="34%"> <input type="Text" name="f_name">
<span class="td1r">* </span></TD>
<TD width="20%"> </TD>
</TR>
<TR>
<TD width="24%" class="td">Middle Name:</TD>
<TD width="34%"> <INPUT type="Text" name="m_name"> </TD>
<TD width="20%"> </TD>
</TR>
<TR>
<TD width="24%" class="td">Last Name:</TD>
<TD width="34%"> <INPUT type="Text" name="l_name"> <span class="td1r">*</span> </TD>
<TD width="20%"> </TD>
</TR>
<TR>
<TD width="24%" class="td">Street Address:</TD>
<TD width="34%"> <input type="text" name="street">
<span class="td1r"> *</span> </TD>
</TR>
<TR>
<TD height=25 width="24%" class="td">City:</TD>
<TD height=25 width="34%"> <input type="text" name="city">
<span class="td1r">*</span> </TD>
</TR>
<TR>
<TD width="24%" class="td">State:</TD>
<TD width="34%"> <select name=states size=1>
<option selected value="">[Select one]</option>
<option value="AL">AL</option>
<option value="AK">AK</option>
<option value="AR">AR</option>
<option value="AZ">AZ</option>
<option value="CA">CA</option>
<option value="CO">CO</option>
<option value="CT">CT</option>
<option value="DE">DE</option>
<option value="DC">DC</option>
<option value="FL">FL</option>
<option value="IN">IA</option>
<option value="KS">KS</option>
<option value="KY">KY</option>
<option value="LA">LA</option>
<option value="ME">ME</option>
<option value="MD">MD</option>
<option value="MA">MA</option>
<option value="MI">MI</option>
<option value="MN">MN</option>
<option value="MS">MS</option>
<option value="MO">MO</option>
<option value="MT">MT</option>
<option value="NE">NE</option>
<option value="NV">NV</option>
<option value="NH">NH</option>
<option value="NJ">NY</option>
<option value="NM">NJ</option>
<option value="NM">NM</option>
<option value="NY">NY</option>
<option value="NC">NC</option>
<option value="ND">ND</option>
<option value="OH">OH</option>
<option value="OK">OK</option>
<option value="OR">OR</option>
<option value="PA">PA</option>
<option value="RI">RI</option>
<option value="SC">SC</option>
<option value="SD">SD</option>
<option value="TX">TX</option>
<option value="UT">UT</option>
<option value="VT">VT</option>
<option value="VA">VA</option>
<option value="WA">WA</option>
<option value="WV">WV</option>
<option value="WI">WI</option>
<option value="WY">WY</option>
</select> <span class="td1r">*</span> </TD>
<TD rowSpan=3 width="20%"> </TD>
</TR>
<TR>
<TD height=35 width="24%" class="td">Zip Code:</TD>
<TD height=35 width="34%"> <INPUT maxLength=10 name="zip" size=8> <span class="td1r">*</span>
</TD>
<TD height=35 width="22%"> </TD>
</TR>
<TR>
<TD height=24 width="24%" class="td">Tel:</TD>
<TD height=24 width="34%"> <input name="phone" type="Text" id="phone">
<span class="td1r">* </span></TD>
<TD height=24 width="22%"> </TD>
</TR>
<TR>
<TD height=27 width="24%" class="td"> Email:</TD>
<TD height=27 width="34%"> <input type="text" name="email">
<span class="td1r">* </span></TD>
<TD height=27 width="20%"> </TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=70%>
<TBODY>
<TR align=center>
<TD align=middle colSpan=5 vAlign=top> <BR>
<DIV align=center>
<INPUT name="submit" type="submit" value="Submit">
</DIV>
</TD>
</TR>
</TBODY>
</TABLE>
</form>
<?php
}
?>
WHY DOES IT SUCK? I can retrieve records from MySQL Server database table and spit them out to an HTML table BUT cannot INSERT any field stuff into the table from the php code I created above. Where is the submitted data going to when I press the "submit" button, Siberia?
Thank you for at least viewing this.
Sincerely,
Milwaukee Mouse