Page 1 of 1

*Solved* Submit button no longer working

Posted: Mon Jul 31, 2006 3:38 am
by mohson
Hi people, for some reason my submit button [see end of code] is no longer adding a record to the database, whats wrong with it, can anyone see an error?

Code: Select all

<?php
/* Connecting, selecting database */
$link = mysql_connect("xxxx", "xxx", "xxxx")
   or die("Could not connect : " . mysql_error());
echo "";
mysql_select_db("contact_management_system") or die("Could not select database");
?>



<body onLoad="focus()"> 

<form method="post" action="processpeople.html">

<table width="100%"  border="0">

    <tr> 
      <td width="17%"><strong>Salutation</strong></td>
      <td width="27%">
        <select name="salutation" style="color: #000000; 
			background-color: #FFFF00">
          <option>Mr</option>
          <option>Mrs</option>
		  <option>Ms</option>
          <option>Miss</option>
		  <option>Prof</option>
		  <option>Dr</option>
        </select>
		</td>
      <td width="27%"><strong>Telephone</strong></td>
      <td width="29%"><input name="telephone" type="text"style="color: #000000; 
			background-color: #FFFFCC" size="20" maxlength="20"></td>
    </tr>
    <tr> 
      <td><strong>First Name</strong></td>
      <td> 
        <input name="firstname" type="text"  size="20"style="color: #000000; 
		background-color: #FFFF00">
      </td>
      <td><strong>Mobile</strong></td>
      <td><input name="mobile" type="text"style="color: #000000; 
			background-color: #FFFFCC" size="20" maxlength="20"></td>
    </tr>
    <tr> 
      <td><strong>Surname</strong></td>
      <td> 
        <input name="surname" type="text" size="15"style="color: #000000; 
			background-color: #FFFF00">
        </td>
     <td><strong>Fax</strong></td>
     <td> 
        <input name="fax" type="text"style="color: #000000; 
			background-color: #FFFFCC" size="20" maxlength="20">
        </td>
		</tr>
    <tr> 
      <td><strong>Organisation</strong></td>
      <td><input name="organisation" type="text" size="20" maxlength="100" style="color: #000000; background-color: #FFFF00"></td>
      
	  <td><strong>E-mail</strong></td>
      <td>
        <input name="email" type="text"style="color: #000000; 
			background-color: #FFFFCC" size="25" maxlength="50">
        </td>
	</tr>
    <tr> 
      <td><strong>Role</strong></font></td>
      <td><input name="role" type="text" size="25"style="color: #000000; 
		background-color: #FFFF00">
        </td>
      <td><strong>Date of Last Contact</strong></td>
      <td>
	  <?php DateSelector("dateoflastcontact_",""); ?>
        </font></td>
		</tr>
    <tr> 
      <td><strong>Address (1)</strong></td>
      <td>
        <input name="address1" type="text"  size="20" style="color: #000000; 
		background-color: #FFFFCC">
      </td>
      <td><strong>Date Contact Again</strong></td>
      <td>
        <?php DateSelector("datecontactagain_",""); ?>
        </td>
    </tr>
    <tr> 
      <td><strong>Address(2) </strong></td>
      <td> <input name="address2" type="text"  size="20"style="color: #000000; 
		background-color: #FFFF00">
        </td>
      <td><strong>OID</strong></td>
      <td>
        <input name="org_id" type="text"style="color: #000000; 
			background-color: #FFFFCC" size="5">
        </td>
    </tr>
      <td><strong>City</strong></font></td>
      <td>
        <input name="city" type="text"  size="20"style="color: #000000; 
		background-color: #FFFF00">
        </td>
    </tr>
    <tr> 
      <td><strong>Post Code</strong></td>
      <td><input name="postcode" type="text" size="7"style="color: #000000; 
			background-color: #FFFFCC">
        </td>
		
  </table>
 
</form>


  <p>
    <input type="submit" name="submit" value = "Enter Information">
	<input type="reset" name="reset" value="clear" style= "color:#000000 ">
	 <?php
if ((isset($_GET['Sent'])) and ($_GET['Sent'] == 'true')) { echo '<b>New Person Added</b>'; }
?>
Thanks

Posted: Mon Jul 31, 2006 3:51 am
by JayBird
Your submit button needs to be inside the form element

Posted: Mon Jul 31, 2006 3:52 am
by CoderGoblin
Your form is closed before the submit button.