My brain is wracked. Could someone please tell me what specific element is missing that is causing my insert form to not insert a record in the database? I suspect it might have something to do with id, but I'm not sure. My id field is an auto-incremented primary key. I've debugged everything already, as it passes all variables, and even tells me that the record has been inserted into the database when passng the $result variable, yet the form does not actually insert a record into the database.
<form action="<?php echo $PHP_SELF; ?>" method="post">
<?php
$db = @mysql_pconnect('host', 'username', 'pw');
if (!$db)
{
echo 'Error: Could not connect to database. Please try again later.';
exit;
}
if(!$Submit)
{
?>
Name: <input type="text" name="fullname" size="30" /><br />
Address: <input type="text" name="address" size="30" /><br />
City: <input type="text" name="city" size="15" />
State: <select name="state">
<option value="AL">AL</option><option value="AK">AK</option>
<option value="AZ">AZ</option><option value="AR">AR</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="GA">GA</option><option value="HI">HI</option>
<option value="ID">ID</option><option value="IL">IL</option>
<option value="IN">IN</option><option value="IA">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">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 selected value="PA">PA</option><option value="RI">RI</option>
<option value="SC">SC</option><option value="SD">SD</option>
<option value="TN">TN</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>
Zip: <input type="text" name="zip" size="5" maxlength="10" /><br />
Phone: <input type="text" name="phone" size="15" />
Ext: <input type="text" name="extension" size="4" /><br />
Fax: <input type="text" name="fax" size="11" /><br />
Email: <input type="text" name="email" size="40" /><br />
Service:<br />
<input type="radio" name="service" value="Accounting/Auditing" />Accounting/Auditing<br />
<input type="radio" name="service"
value="Tax Services" />Tax Services<br />
<input type="radio" name="service"
value="Management Advisory" />Management Advisory<br />
<input type="radio" name="service"
value="Investment Planning" />Investment Planning<br />
<input type="radio" name="service"
value="Peer Review" />Peer Review<br />
Peer Review:<br />
<input type="radio" name="review"
value="System Review" />System Review<br />
<input type="radio" name="review"
value="Engagement Review" />Engagement Review<br />
<input type="radio" name="review"
value="Report Review" />Report Review<br />
Peer Review Year:
<select name="reviewyear">
<option selected value="2003">2003</option><option value="2004">2004</option>
<option value="2005">2005</option><option value="2006">2006</option>
<option value="2007">2007</option><option value="2008">2008</option>
</select>
Peer Review Due Date:
<select name="reviewduemonth">
<option selected value=""></option>
<option value="January">January</option>
<option value="February">February</option>
<option value="March">March</option>
<option value="April">April</option>
<option value="May">May</option>
<option value="June">June</option>
<option value="July">July</option>
<option value="August">August</option>
<option value="September">September</option>
<option value="October">October</option>
<option value="November">November</option>
<option value="December">December</option>
</select>
<select name="reviewdueday">
<option selected value=""></option>
<option value="1">1</option><option value="2">2</option>
<option value="3">3</option><option value="4">4</option>
<option value="5">5</option><option value="6">6</option>
<option value="7">7</option><option value="8">8</option>
<option value="9">9</option><option value="10">10</option>
<option value="11">11</option><option value="12">12</option>
<option value="13">13</option><option value="14">14</option>
<option value="15">15</option><option value="16">16</option>
<option value="17">17</option><option value="18">18</option>
<option value="19">19</option><option value="20">20</option>
<option value="21">21</option><option value="22">22</option>
<option value="23">23</option><option value="24">24</option>
<option value="25">25</option><option value="26">26</option>
<option value="27">27</option><option value="28">28</option>
<option value="29">29</option><option value="30">30</option>
<option value="31">31</option>
</select>,
<select name="reviewdueyear">
<option selected value="2003">2003</option><option value="2004">2004</option>
<option value="2005">2005</option><option value="2006">2006</option>
<option value="2007">2007</option><option value="2008">2008</option>
</select>
<br />
Comments: <textarea name="comments" class="bodytext" style="width:500px" rows="5" cols="75"></text><br /><br />
<input type="hidden" name="id" value="<?php echo $id; ?>" />
<input type="submit" name="Submit" value="Insert" />
<?php
}
?>
<?php
if($Submit == 'Insert')
{
$id=$HTTP_POST_VARS['id'];
$fullname=$HTTP_POST_VARS['fullname'];
$address=$HTTP_POST_VARS['address'];
$city=$HTTP_POST_VARS['city'];
$state=$HTTP_POST_VARS['state'];
$zip=$HTTP_POST_VARS['zip'];
$phone=$HTTP_POST_VARS['phone'];
$extension=$HTTP_POST_VARS['extension'];
$fax=$HTTP_POST_VARS['fax'];
$email=$HTTP_POST_VARS['email'];
$service=$HTTP_POST_VARS['service'];
$review=$HTTP_POST_VARS['review'];
$reviewyear=$HTTP_POST_VARS['reviewyear'];
$reviewduemonth=$HTTP_POST_VARS['reviewduemonth'];
$reviewdueday=$HTTP_POST_VARS['reviewdueday'];
$reviewdueyear=$HTTP_POST_VARS['reviewdueyear'];
$comments=$HTTP_POST_VARS['comments'];
mysql_select_db('dbname');
$query = "INSERT INTO webform VALUES('', $fullname,$address,$city,$state,$zip,$phone,$extension,$fax,$email,$service,$review,$reviewyear,$reviewduemonth,$reviewdueday,$reviewdueyear,$comments)";
mysql_query($query);
if(!$query)
{
echo 'You were unsuccessful in attempting to add '.$fullname.' to your records. Please <a href="insert.php">try</a> again.';
}
if($query)
{
echo 'You were successful in adding '.$fullname.' to your records. <br />
Click <a href="insertclient.php">here</a> to add another client or click a different link in the left side panel.';
}
}
?>
</form>
