Morning eveyrone,

Alrightly then, I've already got an HTML form that uses PHP to send information to an MySQL database.

I also already have a search form that allows me to search for current information that is already in the database.

This is what I want to do, but I am not sure how to go about getting this done correctly:

I have an STF (Service Tracking Form) that I use to track issues.

I want to create a search form to gather the correct information from the MySQL database.

Then I want the user to be able to change and update the fields using the same form they used to send the information to the database, obviosuly it doesn't have to be the EXACT same HTML file but I want the form to look the same.

Lastly I want the user to be able to submit the updated form information and replace the old information.

To give an idea as to how involved this is here is a copy of the form and PHP file used to send information to the database: stf.html, sendstfdb.php.

stf.html

<html>
<head>
<title>Service Tracking Form</title>

<script language="JavaScript" type="text/JavaScript">
function checkForm(thisform)
{

// First check the required fields.

if(document.stf.contactname.value=='')
{
alert("The Contact Name is a required field!");
return false;
}
if(document.stf.contactemail.value=='')
{
alert("The Contact Email is a required field!");
return false;
}
if(document.stf.contactaffiliation.value=='')
{
alert("The Contact Affiliation is a required field!");
return false;
}
if(document.stf.contactmethod.value=='')
{
alert("The Contact Method is a required field!");
return false;
}
if(document.stf.site.value=='')
{
alert("The Site is a required field!");
return false;
}
if(document.stf.wpn.value=='')
{
alert("The WPN is a required field!");
return false;
}
if(document.stf.sitestatus.value=='')
{
alert("The Site Status is a required field!");
return false;
}
if(document.stf.accountmanagerlist.value=='')
{
alert("The Account Manager is a required field! If the Name is not listed please choose 'See Below' and enter the AM's name in the field below the drop down list.");
return false;
}
if(document.stf.submitterlist.value=='')
{
alert("The Sumitter is a required field! If the name is not listed please choose 'See Below' and enter the name in the field below the drop down list.");
return false;
}
if(document.stf.assignedengineerlist.value=='')
{
alert("The Assigned Engineer is a required field! If the name is not listed please choose 'See Below' and enter the name in the field below the drop down list.");
return false;
}
if(document.stf.servicecategorylist.value=='')
{
alert("The Service Category is a required field!");
return false;
}
if(document.stf.stfno.value=='')
{
alert("The STF Number is a required field!");
return false;
}
if(document.stf.stfstatus.value=='')
{
alert("The STF Status is a required field!");
return false;
}
if(document.stf.edfstatus.value=='')
{
alert("The EDF Status is a required field!");
return false;
}
if(document.stf.turnoverstatus.value=='')
{
alert("The Turn Over Status is a required field!");
return false;
}
if(document.stf.datereceived.value=='')
{
alert("The Date Received is a required field!");
return false;
}
if(document.stf.timereceived.value=='')
{
alert("The Time Received is a required field!");
return false;
}
if(document.stf.ampmreceived.value=='')
{
alert("The Time AM/PM Received is a required field!");
return false;
}
if(document.stf.dateresponded.value=='')
{
alert("The Date Responded is a required field!");
return false;
}
if(document.stf.timeresponded.value=='')
{
alert("The Time Responded is a required field!");
return false;
}
if(document.stf.ampmresponded.value=='')
{
alert("The Time AM/PM Responded is a required field!");
return false;
}
if(document.stf.dateresolvedvalue=='')
{
alert("The Date Resolved is a required field!");
return false;
}
if(document.stf.timeresolved.value=='')
{
alert("The Time Resolved is a required field!");
return false;
}
if(document.stf.ampmresolved.value=='')
{
alert("The Time AM/PM Resolved is a required field!");
return false;
}
if(document.stf.servicedescsystemlist.value=='')
{
alert("The Service Description System is a required field! If the system is not listed please choose 'See Below' and enter the system in the field below the drop down list.");
return false;
}
if(document.stf.servicedesccomponentlist.value=='')
{
alert("The Service Description Component is a required field! If the component is not listed please choose 'See Below' and enter the component in the field below the drop down list.");
return false;
}
if(document.stf.servicedescriptioninformation.value=='')
{
alert("The Service Description Information is a required field!");
return false;
}
if(document.stf.serviceresolutioninformation.value=='')
{
alert("The Service Resolution Information is a required field!");
return false;
}
if(document.stf.serviceressystemlist.value=='')
{
alert("The Service Resolution System is a required field! If the system is not listed please choose 'See Below' and enter the system in the field below the drop down list.");
return false;
}
if(document.stf.servicerescomponentlist.value=='')
{
alert("The Service Resolution Component is a required field! If the component is not listed please choose 'See Below' and enter the component in the field below the drop down list.");
return false;
}

chosen = ""
len = document.stf.stfstatus.length;
 
for(i=0;i<len;i++){
 if(document.stf.stfstatus[i].checked){
  chosen = document.stf.stfstatus[i].value;
 }
}
 
if(chosen ==""){
  alert("The STF Status is a required field! Please choose whether the STF is Opened or Closed.");
  return false;
}

chosen = ""
len = document.stf.edfstatus.length;
 
for(i=0;i<len;i++){
 if(document.stf.edfstatus[i].checked){
  chosen = document.stf.edfstatus[i].value;
 }
}
 
if(chosen ==""){
  alert("The EDF Status is a required field! Please choose whether an EDF Status is Opened or Closed.");
return false;
}

chosen = ""
len = document.stf.turnoverstatus.length;
 
for(i=0;i<len;i++){
 if(document.stf.turnoverstatus[i].checked){
  chosen = document.stf.turnoverstatus[i].value;
 }
}
 
if(chosen ==""){
  alert("The Turn Over Status is a required field! Please choose whether the site has been turnec over to the Technical Services Group or not.");
return false;
}

return true;
}
</script>

</head>
<body>
<center>
Note: Once forms have been submitted, they can not be updated or changed.<br />
Please submit only completed and closed STFs.<br />
</center>
<form name="stf" method="POST" action="http://asdtsg.com/sendstfdb.php" onsubmit="return checkForm();">
<!-- onSubmit="return CheckRequiredFields()" -->

<!-- Begin Master Table -->
<table align="left" valign="top" width="650">
<tr>
<td>

<!-- Begin STF Main Table 1 (STF Information) -->
<table align="left" valign="top" width="650">
<tr>
<td style="border: thin black solid;" valign="top">

<!-- Begin Inner Table 1 -->
<table align="left" width="26%">
<tr>

<!-- Begin STF Logo -->
<td valign="top" style="border: 1px black solid;">
<center>
<img src="http://asdtsg.com/images/stories/ARINC%20logo.jpg"><br />
<font face="arial" size="4">
Service Tracking<br />
Form</font>
</center>
</td>
<!-- End STF Logo -->

</tr>
<tr>

<!-- Start STF Contact -->
<td style="border: black solid 1px;">
<font face="arial" size="2">Contact Name:</font><br />
<input type="text" size="18" name="contactname" maxlength="100" /><br />
<font face="arial" size="2">Contact Phone Number 1:</font><br />
<input type="text" size="18" name="contactphone1" maxlength="100" /><br />
<font face="arial" size="2">Contact Phone Number 2:</font><br />
<input type="text" size="18" name="contactphone2" maxlength="100" /><br />
<font face="arial" size="2">Contact Fax Number:</font><br />
<input type="text" size="18" name="contactfax" maxlength="100" /><br />
<font face="arial" size="2">Contact Affiliation:</font><br />
<select name="contactaffiliation">
<option value =""></option>
<option value ="ARINC Personnel">ARINC Personnel</option>
<option value ="Airline Personnel">Airline Personnel</option>
<option value ="Airport Personnel">Airport Personnel</option>
<option value ="AFL">AFL</option>
<option value ="AMS">AMS</option>
<option value ="ASA">ASA</option>
<option value ="Ascent">Ascent</option>
<option value ="BAGS">BAGS</option>
<option value ="BAR">BAR</option>
<option value ="Blackhawk Systems">Blackhawk Systems</option>
<option value ="Citrix Systems Inc.">Citrix Systems Inc.</option>
<option value ="CSI">CSI</option>
<option value ="Damarel">Damarel</option>
<option value ="EDS">EDS</option>
<option value ="ESP">ESP</option>
<option value ="FASL">FASL</option>
<option value ="Fujitsu">Fujitsu</option>
<option value ="GigaNet">GigaNet</option>
<option value ="IBM">IBM</option>
<option value ="IBS">IBS</option>
<option value ="ICT">ICT</option>
<option value ="IDS">IDS</option>
<option value ="IER">IER</option>
<option value ="Intelisys">Intelisys</option>
<option value ="Intermec">Intermec</option>
<option value ="JIT">JIT</option>
<option value ="Kinetics">Kinetics</option>
<option value ="Lufthansa Systems">Lufthansa Systems</option>
<option value ="Menzies Aviation">Menzies Aviation</option>
<option value ="MPHASIS">MPHASIS</option>
<option value ="Navitaire">Navitaire</option>
<option value ="GLOGIC">QLOGIC</option>
<option value ="Sabre">Sabre</option>
<option value ="SITA">SITA</option>
<option value ="ServiceTec">ServiceTec</option>
<option value ="Travsys">Travsys</option>
<option value ="Ultra">Ultra</option>
<option value ="UNISYS">UNISYS</option>
<option value ="Vidtronix">Vidtronix</option>
<option value ="Other">Other</option>
</select><br />
<font face="arial" size="2">Contact Email:</font><br />
<input type="text" size="18" name="contactemail" maxlength="100" /><br />
<font face="arial" size="2">Contact Method:</font><br />
<select name="contactmethod">
<option value =""></option>
<option value ="ais_support@arinc.com">ais_support@arinc.com</option>
<option value ="Hotline">Hotline</option>
<option value ="Internal Identification">Internal Identification</option>
<option value ="Office Email">Office Email</option>
<option value ="Office Phone Call">Office Phone Call</option>
</select>
</td>
<!-- End STF Contact -->

</tr>
</table>
<!-- End Inner Table 1 -->

<!-- Begin Inner Table 2 -->
<table align="left" width="36%">
<tr>

<!-- Begin STF Site -->
<td  style="border: 1px black solid;">
<font face="arial" size="2">Site:</font><br />
<input type="text" size="1" name="site" maxlength="3" /><br />
<font face="arial" size="2">WPN:</font><br />
<input type="text" size="18" name="wpn"/><br />
<font face="arial" size="2">Site Status:</font><br />
<select name="sitestatus">
<option value =""></option>
<option value ="All">All</option>
<option value ="Airport Systems Division (ASD)">Airport Systems Division (ASD)</option>
<option value ="Asia Pacific Division (APD)">Asia Pacific Division (APD)</option>
<option value ="Europe Middle East Africa (EMEA)">Europe Middle East Africa (EMEA)</option>
</select><br />
<font face="arial" size="2">Account Manager:</font><br />
<select name="accountmanagerlist">
<option value =""></option>
<option value ="All">All</option>
<option value ="----------APD----------">----------APD----------</option>
<option value ="Allen Olano">Allen Olano</option>
<option value ="Glen Oliveiro">Glen Oliveiro</option>
<option value ="Koichi Mikami">Koichi Mikami</option>
<option value ="Sabrina Lai">Sabrina Lai</option>
<option value ="Willy Kim">Willy Kim</option>
<option value ="Yoshiyuki Tawara">Yoshiyuki Tawara</option>
<option value ="----------ASD----------">----------ASD----------</option>
<option value ="Carmen Corraro">Carmen Corraro</option>
<option value ="Grant Decker">Grant Decker</option>
<option value ="Jeff Byers">Jeff Byers</option>
<option value ="John Dungan">John Dungan</option>
<option value ="Marian Bracho">Marian Bracho</option>
<option value ="Salley Philpott">Salley Philpott</option>
<option value ="Tawnya Templeton">Tawnya Templeton</option>
<option value ="Tony Blockton">Tony Blockton</option>
<option value ="---------EMEA---------">---------EMEA---------</option>
<option value ="Carlos Jodar">Carlos Jodar</option>
<option value ="Chris Young">Chris Young</option>
<option value ="Debra Lawrence">Debra Lawrence</option>
<option value ="James Needham">James Needham</option>
<option value ="Linda Judge">Linda Judge</option>
<option value ="Mahira Khan">Mahira Khan</option>
<option value ="Marco Delu">Marco Delu</option>
<option value ="Melanie Reiser">Melanie Reiser</option>
<option value ="Peter Webb">Peter Webb</option>
<option value ="Rob Debruijn">Rob Debruijn</option>
<option value ="Robin Santall">Robin Santall</option>
<option value ="Stefano Boccafoglia">Stefano Boccafoglia</option>
<option value ="Taania Hobden">Taania Hobden</option>
<option value ="Tracey Atkinson">Tracey Atkinson</option>
<option value ="---------Other---------">---------Other---------</option>
<option value ="See Below">See Below</option>
</select><br />
<input type="text" size="18" name="accountmanagernotlisted"/><br />
</td>
<!-- End STF Site -->

</tr>
<tr>

<!-- Begin STF Submitter -->
<td align="left" valign="top"  style="border: 1px black solid;">
<font face="arial" size="2">Submitter:</font><br />
<select name="submitterlist">
<option value =""></option>
<option value ="Aaron Downing">Aaron Downing</option>
<option value ="Ercan Kadakal">Ercan Kadakal</option>
<option value ="Greg Gatz">Greg Gatz</option>
<option value ="Johnathan Morlock">Johnathan Morlock</option>
<option value ="Matt Sirkis">Matt Sirkis</option>
<option value ="Patrick Hicks">Patrick Hicks</option>
<option value ="Stephen Khan">Stephen Khan</option>
<option value ="---------Other---------">---------Other---------</option>
<option value ="See Below">See Below</option>
</select><br />
<input type="text" size="18" name="submitternotlisted"/><br />
<font face="arial" size="2">Assigned Engineer:</font><br />
<select name="assignedengineerlist">
<option value =""></option>
<option value ="Aaron Downing">Aaron Downing</option>
<option value ="Ercan Kadakal">Ercan Kadakal</option>
<option value ="Greg Gatz">Greg Gatz</option>
<option value ="Johnathan Morlock">Johnathan Morlock</option>
<option value ="Matt Sirkis">Matt Sirkis</option>
<option value ="Patrick Hicks">Patrick Hicks</option>
<option value ="Stephen Khan">Stephen Khan</option>
<option value ="---------Other---------">---------Other---------</option>
<option value ="See Below">See Below</option>
</select><br />
<input type="text" size="18" name="assignedengineernotlisted"/>
</td>
<!-- End STF Submitter -->

</tr>
<tr>

<!-- Start Issue Info -->
<td style="border: black solid 1px;" align="left">
<font face="arial" size="2">Service Category</font><br />
<select name="servicecategorylist">
<option value =""></option>
<option value ="ARINC Software">ARINC Software</option>
<option value ="Circuit Error">Circuit Error</option>
<option value ="Configuration Change">Configuration Change</option>
<option value ="Configuration Error">Configuration Error</option>
<option value ="Hardware Error">Hardware Error</option>
<option value ="Host Error">Host Error</option>
<option value ="Information Request">Information Request</option>
<option value ="Network Error">Network Error</option>
<option value ="Power Outage">Power Outage</option>
<option value ="Software Deployment">Software Deployment</option>
<option value ="Software Upgrade">Software Upgrade</option>
<option value ="Third-Party Software">Third-Party Software</option>
<option value ="User Error">User Error</option>
<option value ="Unknown">Unknown</option>
<option value ="Other">Other</option>
</select><br />
</td>
<!-- End Issue Info -->

</tr>
</table>
<!-- End Inner Table 2 -->

<!-- Begin Inner Table 3 -->
<table align="left" width="35%" valign="top">
<tr>
<td style="border: 1px black solid">

<!-- Begin STF No. -->
<table>
<tr>
<td align="left" valign="top">
<font face="arial" size="2">STF No.:</font><br />
<input type="text" size="10" name="stfno" maxlength="8" /><br />
<font face="arial" size="2">EDF No.:</font><br />
<input type="text" size="10" name="edfno" maxlength="20" /><br />
<font face="arial" size="2">Ext. Ref. No.:</font><br />
<input type="text" size="10" name="erno" maxlength="20" />
</td>
<!-- End STF No. -->

<!-- Begin STF Status -->
<td align="left" valign="top">
<table width="100%">
<tr>
<td>
<font face="arial" size="2">STF Status:</font><br />
</td>
</tr>
</table>
<table>
<tr>
<td>
<input type="radio" name="stfstatus" value="Open" />
<font face="arial" size="1">Open</font>
</td>
<td>
<input type="radio" name="stfstatus" value="Closed" />
<font face="arial" size="1">Closed</font>
</td>
</tr>
</table>
<table width="100%">
<tr>
<td>
<font face="arial" size="2">EDF Status:</font><br />
</td>
</tr>
</table>
<table>
<tr>
<td>
<input type="radio" name="edfstatus" value="Open" />
<font face="arial" size="1">Open</font>
</td>
<td>
<input type="radio" name="edfstatus" value="Closed" />
<font face="arial" size="1">Closed</font>
</td>
</tr>
</table>
<table width="100%">
<tr>
<td>
<font face="arial" size="2">Turn Over Status:</font><br />
</td>
</tr>
</table>
<table>
<tr>
<td>
<input type="radio" name="turnoverstatus" value="Yes" />
<font face="arial" size="1">Yes</font>
</td>
<td>
<input type="radio" name="turnoverstatus" value="No" />
<font face="arial" size="1">No</font>
</td>
</tr>
</table>
</td>
</tr>
</table>
<!-- End STF Status -->

</td>
</tr>
<tr>
<td style="border: 1px black solid">

<!-- Begin STF Date/Time -->
<table>
<tr>
<td>
<font face="arial" size="2">Date/Time Received:</font><br />
<input name="datereceived" type="text" size="6" maxlength="10" /> @ <input name="timereceived" type="text" size="6" maxlength="5" /><select name="ampmreceived"><option value =""></option><option value ="AM">AM</option><option value ="PM">PM</option></select><br />
<font face="arial" size="2">Date/Time Responded:</font><br />
<input name="dateresponded" type="text" size="6" maxlength="10" /> @ <input name="timeresponded" type="text" size="6" maxlength="5" /><select name="ampmresponded"><option value =""></option><option value ="AM">AM</option><option value ="PM">PM</option></select><br />
<font face="arial" size="2">Date/Time Resolved:</font><br />
<input name="dateresolved" type="text" size="6" maxlength="10" /> @ <input name="timeresolved" type="text" size="6" maxlength="5" /><select name="ampmresolved"><option value =""></option><option value ="AM">AM</option><option value ="PM">PM</option></select><br />
<font face="arial" size="2">Date/Time Scheduled:</font><br />
<input name="datescheduled" type="text" size="6" maxlength="10" /> @ <input name="timescheduled" type="text" size="6" maxlength="5" /><select name="ampmscheduled"><option value =""></option><option value ="AM">AM</option><option value ="PM">PM</option></select><br />
</td>
</tr>
</table>
<!-- End STF Date/Time -->

</tr>
</table>
<!-- End Inner Table 3 -->

</td>
</tr>
</table>
<!-- End STF Main Table 1 (STF Information) -->

</td>
</tr>
<tr>
<td>

<!-- Begin STF Main Table 2 (STF Service Description) -->
<table align="left" valign="top" width="650">
<tr>
<td style="border: thin black solid;" valign="top">

<!-- Begin Service Description Table -->
<table width="99%">
<tr>
<td width="100%">
<font face="arial" size="2">Service Description</font>
</td>
</tr>
<tr>
<td width="32%" style="border: 1px black solid;" valign="top">
<font face="arial" size="2">System:</font><br />
<select name="servicedescsystemlist">
<option value =""></option>
<option value ="AODB">AODB</option>
<option value ="BRS">BRS</option>
<option value ="CUSS">CUSS</option>
<option value ="FIDS">FIDS</option>
<option value ="iMuse">iMuse</option>
<option value ="MUSE/NT">MUSE/NT</option>
<option value ="RPS">RPS</option>
<option value ="Security">Security</option>
<option value ="vMuse">vMuse</option>
<option value ="---------Other---------">---------Other---------</option>
<option value ="See Below">See Below</option>
</select><br />
<input name="servicedescsystemnotlisted" type="text" size="29" />
</td>
<td width="32%" style="border: 1px black solid;" valign="top">
<font face="arial" size="2">Component:</font><br />
<select name="servicedesccomponentlist">
<option value =""></option>
<option value ="AirDB">AirDB</option>
<option value ="AirVue">AirVue</option>
<option value ="ATTS">ATTS</option>
<option value ="AVRS">AVRS</option>
<option value ="Babel">Babel</option>
<option value ="BagLink">BagLink</option>
<option value ="BDCS">BDCS</option>
<option value ="EasyCheck">EasyCheck</option>
<option value ="GateFlow">GateFlow</option>
<option value ="IDMS">IDMS</option>
<option value ="iMuse Express">iMuse Express</option>
<option value ="InfoHub">InfoHub</option>
<option value ="LBA2">LBA2</option>
<option value ="LDCS">LDCS</option>
<option value ="LodeStone">LodeStone</option>
<option value ="Onvoy">Onvoy</option>
<option value ="Tagtrak">Tagtrak</option>
<option value ="Vanguards">Vanguard</option>
<option value ="---------Other---------">---------Other---------</option>
<option value ="See Below">See Below</option>
</select><br />
<input name="servicedesccomponentnotlisted" type="text"  size="29" />
</td>
<td width="32%" style="border: 1px black solid;" valign="top">
<font face="arial" size="2">Revision:</font><br />
<input name="servicedescrevision" type="text" size="29" /><br />
<font face="arial" size="2">Anticipated Global Effects:</font><br />
<input name="anticipatedglobaleffect" type="text" size="29" /><br />
</td>
</tr>
</table>
<table width="100%">
<tr>
<td width="100%">
<font face="arial" size="2">Service Description Information:</font><br />
<center>
<textarea name="servicedescriptioninformation" cols="73" rows="20"></textarea>
</center>
</td>
</tr>
</table>
</td>
</tr>
</table>
<!-- End STF Main Table 2 (STF Service Description) -->

</td>
</tr>
<tr>
<td>

<!-- Begin STF Main Table 3 (STF Service Resolution) -->
<table align="left" valign="top" width="650">
<tr>
<td style="border: thin black solid;" valign="top">

<!-- Begin Service Resolution Table -->
<table width="640">
<tr>
<td width="100%">
<font face="arial" size="2">Service Resolution</font>
</td>
</tr>
<tr>
<td width="32%" style="border: 1px black solid;" valign="top">
<font face="arial" size="2">System:</font><br />
<select name="serviceressystemlist">
<option value =""></option>
<option value ="AODB">AODB</option>
<option value ="BRS">BRS</option>
<option value ="CUSS">CUSS</option>
<option value ="FIDS">FIDS</option>
<option value ="iMuse">iMuse</option>
<option value ="MUSE/NT">MUSE/NT</option>
<option value ="RPS">RPS</option>
<option value ="Security">Security</option>
<option value ="vMuse">vMuse</option>
<option value ="---------Other---------">---------Other---------</option>
<option value ="See Below">See Below</option>
</select><br />
<input name="serviceressystemnotlisted" type="text" size="29" />
</td>
<td width="32%" style="border: 1px black solid;" valign="top">
<font face="arial" size="2">Component:</font><br />
<select name="servicerescomponentlist">
<option value =""></option>
<option value ="AirDB">AirDB</option>
<option value ="AirVue">AirVue</option>
<option value ="ATTS">ATTS</option>
<option value ="AVRS">AVRS</option>
<option value ="Babel">Babel</option>
<option value ="BagLink">BagLink</option>
<option value ="BDCS">BDCS</option>
<option value ="EasyCheck">EasyCheck</option>
<option value ="GateFlow">GateFlow</option>
<option value ="IDMS">IDMS</option>
<option value ="iMuse Express">iMuse Express</option>
<option value ="InfoHub">InfoHub</option>
<option value ="LBA2">LBA2</option>
<option value ="LDCS">LDCS</option>
<option value ="LodeStone">LodeStone</option>
<option value ="Onvoy">Onvoy</option>
<option value ="Tagtrak">Tagtrak</option>
<option value ="Vanguards">Vanguard</option>
<option value ="---------Other---------">---------Other---------</option>
<option value ="See Below">See Below</option>
</select><br />
<input name="servicerescomponentnotlisted" type="text" size="29" />
</td>
<td width="32%" style="border: 1px black solid;" valign="top">
<font face="arial" size="2">Revision:</font><br />
<input name="serviceresrevision" type="text" size="29" /><br />
</td>
</tr>
</table>
<table width="100%">
<tr>
<td width="100%">
<font face="arial" size="2">Service Resolution Information:</font><br />
<center>
<textarea name="serviceresolutioninformation" cols="73" rows="20"></textarea>
</center>
</td>
</tr>
</table>
<input type="submit" name="submit" value="Submit STF"  /><input type="reset" value="Reset STF">
</td>
<td>&nbsp;</td>
</tr>
</table>
<!-- End STF Main Table 3 (STF Service Resolution) -->

</td>
</tr>
</table>
<!-- End Master Table -->

</form>

</body>
</html>

sendstfdb.php

<?php
$con = mysql_connect("localhost","stf","stf"); //Replace with your actual MySQL DB Username and Password
if (!$con) 
{ 
die('Could not connect to the ASDTSG database: ' . mysql_error()); 
} 
mysql_select_db("asdtsg", $con); //Replace with your MySQL DB Name
$contactname=mysql_real_escape_string($_POST['contactname']); //This value has to be the same as in the HTML form file  //This value has to be the same as in the HTML form file
$contactphone1=mysql_real_escape_string($_POST['contactphone1']); //This value has to be the same as in the HTML form file
$contactphone2=mysql_real_escape_string($_POST['contactphone2']); //This value has to be the same as in the HTML form file
$contactfax=mysql_real_escape_string($_POST['contactfax']); //This value has to be the same as in the HTML form file
$contactaffiliation=mysql_real_escape_string($_POST['contactaffiliation']); //This value has to be the same as in the HTML form file
$contactemail=mysql_real_escape_string($_POST['contactemail']); //This value has to be the same as in the HTML form file
$contactmethod=mysql_real_escape_string($_POST['contactmethod']); //This value has to be the same as in the HTML form file
$site=mysql_real_escape_string($_POST['site']); //This value has to be the same as in the HTML form file
$wpn=mysql_real_escape_string($_POST['wpn']); //This value has to be the same as in the HTML form file
$sitestatus=mysql_real_escape_string($_POST['sitestatus']); //This value has to be the same as in the HTML form file
$accountmanagerlist=mysql_real_escape_string($_POST['accountmanagerlist']); //This value has to be the same as in the HTML form file
$accountmanagernotlisted=mysql_real_escape_string($_POST['accountmanagernotlisted']); //This value has to be the same as in the HTML form file
$submitterlist=mysql_real_escape_string($_POST['submitterlist']); //This value has to be the same as in the HTML form file
$submitternotlisted=mysql_real_escape_string($_POST['submitternotlisted']); //This value has to be the same as in the HTML form file
$assignedengineerlist=mysql_real_escape_string($_POST['assignedengineerlist']); //This value has to be the same as in the HTML form file
$assignedengineernotlisted=mysql_real_escape_string($_POST['assignedengineernotlisted']); //This value has to be the same as in the HTML form file
$servicecategorylist=mysql_real_escape_string($_POST['servicecategorylist']); //This value has to be the same as in the HTML form file
$stfno=mysql_real_escape_string($_POST['stfno']); //This value has to be the same as in the HTML form file
$edfno=mysql_real_escape_string($_POST['edfno']); //This value has to be the same as in the HTML form file
$erno=mysql_real_escape_string($_POST['erno']); //This value has to be the same as in the HTML form file
$stfstatus=mysql_real_escape_string($_POST['stfstatus']); //This value has to be the same as in the HTML form file
$edfstatus=mysql_real_escape_string($_POST['edfstatus']); //This value has to be the same as in the HTML form file
$turnoverstatus=mysql_real_escape_string($_POST['turnoverstatus']); //This value has to be the same as in the HTML form file
$datereceived=mysql_real_escape_string($_POST['datereceived']); //This value has to be the same as in the HTML form file
$timereceived=mysql_real_escape_string($_POST['timereceived']); //This value has to be the same as in the HTML form file
$ampmreceived=mysql_real_escape_string($_POST['ampmreceived']); //This value has to be the same as in the HTML form file
$dateresponded=mysql_real_escape_string($_POST['dateresponded']); //This value has to be the same as in the HTML form file
$timeresponded=mysql_real_escape_string($_POST['timeresponded']); //This value has to be the same as in the HTML form file
$ampmresponded=mysql_real_escape_string($_POST['ampmresponded']); //This value has to be the same as in the HTML form file
$dateresolved=mysql_real_escape_string($_POST['dateresolved']); //This value has to be the same as in the HTML form file
$timeresolved=mysql_real_escape_string($_POST['timeresolved']); //This value has to be the same as in the HTML form file
$ampmresolved=mysql_real_escape_string($_POST['ampmresolved']); //This value has to be the same as in the HTML form file
$datescheduled=mysql_real_escape_string($_POST['datescheduled']); //This value has to be the same as in the HTML form file
$timescheduled=mysql_real_escape_string($_POST['timescheduled']); //This value has to be the same as in the HTML form file
$ampmscheduled=mysql_real_escape_string($_POST['ampmscheduled']); //This value has to be the same as in the HTML form file
$servicedescsystemlist=mysql_real_escape_string($_POST['servicedescsystemlist']); //This value has to be the same as in the HTML form file
$servicedescsystemnotlisted=mysql_real_escape_string($_POST['servicedescsystemnotlisted']); //This value has to be the same as in the HTML form file
$servicedesccomponentlist=mysql_real_escape_string($_POST['servicedesccomponentlist']); //This value has to be the same as in the HTML form file
$servicedesccomponentnotlisted=mysql_real_escape_string($_POST['servicedesccomponentnotlisted']); //This value has to be the same as in the HTML form file
$servicedescrevision=mysql_real_escape_string($_POST['servicedescrevision']); //This value has to be the same as in the HTML form file
$anticipatedglobaleffect=mysql_real_escape_string($_POST['anticipatedglobaleffect']); //This value has to be the same as in the HTML form file
$servicedescriptioninformation=mysql_real_escape_string($_POST['servicedescriptioninformation']); //This value has to be the same as in the HTML form file
$serviceressystemlist=mysql_real_escape_string($_POST['serviceressystemlist']); //This value has to be the same as in the HTML form file
$serviceressystemnotlisted=mysql_real_escape_string($_POST['serviceressystemnotlisted']); //This value has to be the same as in the HTML form file
$servicerescomponentlist=mysql_real_escape_string($_POST['servicerescomponentlist']); //This value has to be the same as in the HTML form file
$servicerescomponentnotlisted=mysql_real_escape_string($_POST['servicerescomponentnotlisted']); //This value has to be the same as in the HTML form file
$serviceresrevision=mysql_real_escape_string($_POST['serviceresrevision']); //This value has to be the same as in the HTML form file
$serviceresolutioninformation=mysql_real_escape_string($_POST['serviceresolutioninformation']); //This value has to be the same as in the HTML form file

/* if (!($contactname && !$contactaffiliation && !$contactmethod && !$site && !$sitestatus && !$submitterlist && !$assignedengineerlist && !$servicecategorylist && !$stfno && !$stfstatus && !$datereceived && !$timereceived && !$ampmreceived && !$dateresponded && !$timeresponded && !$ampmresponded && !$dateresolved && !$timeresolved && !$ampmresolved && !$servicedescriptioninformation && !$serviceresolutioninformation)) {
die('Please fill out all of the required fields.'); 
}
else { */

$sql="INSERT INTO stf (contactname, contactphone1, contactphone2, contactfax, contactaffiliation, contactemail, contactmethod, site, wpn, sitestatus, accountmanagerlist, accountmanagernotlisted, submitterlist, submitternotlisted, assignedengineerlist, assignedengineernotlisted, servicecategorylist, stfno, edfno, erno, stfstatus, edfstatus, turnoverstatus, datereceived, timereceived, ampmreceived, dateresponded, timeresponded, ampmresponded, dateresolved, timeresolved, ampmresolved, datescheduled, timescheduled, ampmscheduled, servicedescsystemlist, servicedescsystemnotlisted, servicedesccomponentlist, servicedesccomponentnotlisted, servicedescrevision, anticipatedglobaleffect, servicedescriptioninformation, serviceressystemlist, serviceressystemnotlisted, servicerescomponentlist, servicerescomponentnotlisted, serviceresrevision, serviceresolutioninformation) VALUES ('$contactname', '$contactphone1', '$contactphone2', '$contactfax', '$contactaffiliation', '$contactemail', '$contactmethod', '$site', '$wpn', '$sitestatus', '$accountmanagerlist', '$accountmanagernotlisted', '$submitterlist', '$submitternotlisted', '$assignedengineerlist', '$assignedengineernotlisted', '$servicecategorylist', '$stfno', '$edfno', '$erno', '$stfstatus', '$edfstatus', '$turnoverstatus', '$datereceived', '$timereceived', '$ampmreceived', '$dateresponded', '$timeresponded', '$ampmresponded', '$dateresolved', '$timeresolved', '$ampmresolved', '$datescheduled', '$timescheduled', '$ampmscheduled', '$servicedescsystemlist', '$servicedescsystemnotlisted', '$servicedesccomponentlist', '$servicedesccomponentnotlisted', '$servicedescrevision', '$anticipatedglobaleffect', '$servicedescriptioninformation', '$serviceressystemlist', '$serviceressystemnotlisted', '$servicerescomponentlist', '$servicerescomponentnotlisted', '$serviceresrevision', '$serviceresolutioninformation')"; /* 'stf' is the name of the MySQL table where the form data will be saved. The names between the ( and ) are the respective table fields. After that, all of the '$xxxx' are the related field names form the list above which are the same names within the HTML form. */

if (!mysql_query($sql,$con)) {
 die('Error: ' . mysql_error()); 
} 
echo "The STF was successfully added to the database."; 
mysql_close($con);
?>

OK, now since you know how big the form is I will also post the search form and the php file it uses: searchstfs.html and results.php

searchstfs.html

<form method="post" action="http://asdtsg.com/results.php" target="_blank">
<div align="center">
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td bordercolor="#000000">
<p align="center">
<select name="metode" size="1">
<option value="contactname">Contact Name</option>
<option value="contactphone1">Contact Phone 1</option>
<option value="contactphone2">Contact Phone 2</option>
<option value="contactfax">Contact Fax</option>
<option value="contactaffiliation">Contact Affiliation</option>
<option value="contactemail">Contact Email</option>
<option value="contactmethod">Contact Method</option>
<option value="site">Site</option>
<option value="wpn">WPN</option>
<option value="sitestatus">Site Status</option>
<option value="accountmanagerlist">Account Manager 1</option>
<option value="accountmanagernotlisted">Account Manager 2</option>
<option value="submitterlist">Submitter 1</option>
<option value="submitternotlisted">Submitter 2</option>
<option value="assignedengineerlist">Assigned Engineer 1</option>
<option value="assignedengineernotlisted">Assigned Engineer 2</option>
<option value="servicecategorylist">Service Category</option>
<option value="stfno">STF Number</option>
<option value="edfno">EDF Number</option>
<option value="erno">External Ref. Number</option>
<option value="stfstatus">STF Status</option>
<option value="edfstatus">EDF Status</option>
<option value="turnoverstatus">Turn Over Status</option>
<option value="datereceived">Date Received</option>
<option value="timereceived">Time Received</option>
<option value="ampmreceived">AM/PM Received</option>
<option value="dateresponded">Date Responded</option>
<option value="timeresponded">Time Responded</option>
<option value="ampmresponded">AM/PM Responded</option>
<option value="dateresolved">Date Resolved</option>
<option value="timeresolved">Time Resolved</option>
<option value="ampmresolved">AM/PM Resolved</option>
<option value="datescheduled">Date Scheduled</option>
<option value="timescheduled">Time Scheduled</option>
<option value="ampmscheduled">AM/PM Scheduled</option>
<option value="servicedescsystemlist">Service Description System 1</option>
<option value="servicedescsystemnotlisted">Service Description System 2</option>
<option value="servicedesccomponentlist">Service Description Component 1</option>
<option value="servicedesccomponentnotlisted">Service Description Component 2</option>
<option value="servicedescrevision">Service Description Revision</option>
<option value="anticipatedglobaleffect">Anticipated Global Effect</option>
<option value="servicedescriptioninformation">Service Description Information</option>
<option value="serviceressystemlist">Service Resolution System 1</option>
<option value="serviceressystemnotlisted">Service Resolution System 2</option>
<option value="servicerescomponentlist">Service Resolution Component 1</option>
<option value="servicerescomponentnotlisted">Service Resolution Component 2</option>
<option value="serviceresrevision">Service Resolution Revision</option>
<option value="serviceresolutioninformation">Service Resolution Information</option>
</select> <input type="text" name="search" size="25">  <br>
Press 'Search' to search the STF Database: <input type="submit" value="Search..." name="Search"></p>
<font color="red">STF Search Hints:</font><br />
<li>By pressing 'Search...' with no criteria in any field, all of the STFs within the database will display. They will be in order as they were entered into the database.</li>
<li>You can search for any single character, or multiple characters, under any field.</li>
<li>If the STF database can not be accessed for any reason, an error message will be displayed.</li>
</td>
</tr>
</table>
</div>
</form>

results.php

<?php
?>
<!-- Begin Master Table -->
<table align="left" valign="top">
<tr>
<td>
<?php
$hostname = "localhost"; // Our DB server.
$username = "stf"; // The username you created for this database.
$password = "stf"; // The password you created for the username.
$usertable = "stf"; // The name of the table you made.
$dbName = "asdtsg"; // This is the name of the database you made.

MYSQL_CONNECT($hostname, $username, $password) OR DIE("Unable to connect to the Database. Please make sure that your username/password/DB name and host are correct.<br />Also, make sure that the database can be accessed. You can test this by going to the following link: <a href='http://asdtsg.com/dbtest.php'>http://asdtsg.com/dbtest.php</a>.");
@mysql_select_db( "$dbName") or die("Unable to select database. Please verify that the database name is correct.");
?>
<?php

//error message (not found message)begins
$XX = "Sorry, an STF was not found with the search criteria: '<font color='red'>$search</font>'!<br /> Please close this window and try again.";

//query details table begins
$query = mysql_query("SELECT * FROM stf WHERE $metode LIKE '%$search%' LIMIT 0, 50");
while ($row = @mysql_fetch_array($query))
{
$variable1=$row["contactname"];
$variable2=$row["contactphone1"];
$variable3=$row["contactphone2"];
$variable4=$row["contactfax"];
$variable5=$row["contactaffiliation"];
$variable6=$row["contactemail"];
$variable7=$row["contactmethod"];
$variable8=$row["site"];
$variable9=$row["wpn"];
$variable10=$row["sitestatus"];
$variable11=$row["accountmanagerlist"];
$variable12=$row["accountmanagernotlisted"];
$variable13=$row["submitterlist"];
$variable14=$row["submitternotlisted"];
$variable15=$row["assignedengineerlist"];
$variable16=$row["assignedengineernotlisted"];
$variable17=$row["servicecategorylist"];
$variable18=$row["stfno"];
$variable19=$row["edfno"];
$variable20=$row["erno"];
$variable21=$row["stfstatus"];
$variable22=$row["edfstatus"];
$variable23=$row["turnoverstatus"];
$variable24=$row["datereceived"];
$variable25=$row["timereceived"];
$variable26=$row["ampmreceived"];
$variable27=$row["dateresponded"];
$variable28=$row["timeresponded"];
$variable29=$row["ampmresponded"];
$variable30=$row["dateresolved"];
$variable31=$row["timeresolved"];
$variable32=$row["ampmresolved"];
$variable33=$row["datescheduled"];
$variable34=$row["timescheduled"];
$variable35=$row["ampmscheduled"];
$variable36=$row["servicedescsystemlist"];
$variable37=$row["servicedescsystemnotlisted"];
$variable38=$row["servicedesccomponentlist"];
$variable39=$row["servicedesccomponentnotlisted"];
$variable40=$row["servicedescrevision"];
$variable41=$row["anticipatedglobaleffect"];
$variable42=$row["servicedescriptioninformation"];
$variable43=$row["serviceressystemlist"];
$variable44=$row["serviceressystemnotlisted"];
$variable45=$row["servicerescomponentlist"];
$variable46=$row["servicerescomponentnotlisted"];
$variable47=$row["serviceresrevision"];
$variable48=$row["serviceresolutioninformation"];

//table layout for results
print ('<tr>');
print ('<td>');
print ('<br style="page-break-before: always">');

//Begin STF Main Table 1 STF Information
print ('<table align="left" valign="top" width="650">');
print ('<tr>');
print ('<td style="border: thin black solid;" valign="top">');

//Begin Inner Table 1
print ('<table align="left" width="177">');
print ('<tr>');
print ('<td valign="top" style="border: 1px black solid;">');
print ('<center>');
print ('<img src="/images/stories/ARINC%20logo.jpg"><br />');
print ('<font face="arial" size="4">');
print ('Service Tracking<br />');
print ('Form</font>');
print ('</center>');
print ('</td>');
//End STF Logo

print ('</tr>');
print ('<tr>');
print ('<td style="border: black solid 1px;"><font face="arial" size="2">Contact Name:</font><br />');
print ("$variable1");
print ('<br />');
print ('<font face="arial" size="2">Contact Phone Number 1:</font><br />');
print ("$variable2");
print ('<br />');
print ('<font face="arial" size="2">Contact Phone Number 2:</font><br />');
print ("$variable3");
print ('<br />');
print ('<font face="arial" size="2">Contact Fax Number:</font><br />');
print ("$variable4");
print ('<br />');
print ('<font face="arial" size="2">Contact Affiliation:</font><br />');
print ("$variable5");
print ('<br />');
print ('<font face="arial" size="2">Contact Email:</font><br />');
print ("$variable6");
print ('<br />');
print ('<font face="arial" size="2">Contact Method:</font><br />');
print ("$variable7");
print ('<br />');
print ('</td>');
//End STF Contact

print ('</tr>');
print ('</table>');
//End Inner Table 1

//Begin Inner Table 2
print ('<table align="left" width="234">');
print ('<tr>');

//Begin STF Site
print ('<td  style="border: 1px black solid;">');
print ('<font face="arial" size="2">Site:</font><br />');
print ("$variable8");
print ('<br />');
print ('<font face="arial" size="2">WPN:</font><br />');
print ("$variable9");
print ('<br />');
print ('<font face="arial" size="2">Site Status:</font><br />');
print ("$variable10");
print ('<br />');
print ('<font face="arial" size="2">Account Manager:</font><br />');
print ("$variable11");
print ('<br />');
print ("$variable12");
print ('<br />');
print ('</td>');
//End STF Site

print ('</tr>');
print ('<tr>');

//Begin STF Submitter
print ('<td align="left" valign="top"  style="border: 1px black solid;">');
print ('<font face="arial" size="2">Submitter:</font><br />');
print ("$variable13");
print ('<br />');
print ("$variable14");
print ('<br />');
print ('<font face="arial" size="2">Assigned Engineer:</font><br />');
print ("$variable15");
print ('<br />');
print ("$variable16");
print ('<br />');
print ('</td>');
//End STF Submitter

print ('</tr>');
print ('<tr>');

//Start Issue Info
print ('<td style="border: black solid 1px;" align="left">');
print ('<font face="arial" size="2">Service Category</font><br />');
print ("$variable17");
print ('<br />');
print ('</td>');
//End Issue Info

print ('</tr>');
print ('</table>');
//End Inner Table 2

//Begin Inner Table 3
print ('<table align="left" width="228" valign="top">');
print ('<tr>');
print ('<td style="border: 1px black solid">');

//Begin STF No
print ('<table>');
print ('<tr>');
print ('<td align="left" valign="top">');
print ('<font face="arial" size="2">STF No.:</font><br />');
print ("$variable18");
print ('<br />');
print ('<font face="arial" size="2">EDF No.:</font><br />');
print ("$variable19");
print ('<br />');
print ('<font face="arial" size="2">Ext. Ref. No.:</font><br />');
print ("$variable20");
print ('<br />');
print ('</td>');
//End STF No

//Begin STF Status
print ('<td align="left" valign="top">');
print ('<table width="100%">');
print ('<tr>');
print ('<td>');
print ('<font face="arial" size="2">STF Status:</font><br />');
print ('</td>');
print ('</tr>');
print ('</table>');
print ('<table>');
print ('<tr>');
print ('<td>');
print ("$variable21");
print ('<br />');
print ('</td>');
print ('</tr>');
print ('</table>');
print ('<table width="100%">');
print ('<tr>');
print ('<td>');
print ('<font face="arial" size="2">EDF Status:</font><br />');
print ('</td>');
print ('</tr>');
print ('</table>');
print ('<table>');
print ('<tr>');
print ('<td>');
print ("$variable22");
print ('<br />');
print ('</td>');
print ('</tr>');
print ('</table>');
print ('<table width="100%">');
print ('<tr>');
print ('<td>');
print ('<font face="arial" size="2">Turn Over Status:</font><br />');
print ('</td>');
print ('</tr>');
print ('</table>');
print ('<table>');
print ('<tr>');
print ('<td>');
print ("$variable23");
print ('<br />');
print ('</td>');
print ('</tr>');
print ('</table>');
print ('</td>');
print ('</tr>');
print ('</table>');
//End STF Status

print ('</td>');
print ('</tr>');
print ('<tr>');
print ('<td style="border: 1px black solid">');

//Begin STF Date/Time
print ('<table>');
print ('<tr>');
print ('<td>');
print ('<font face="arial" size="2">Date/Time Received:</font><br />');
print ("$variable24 @ $variable25 $variable26");
print ('<br />');
print ('<font face="arial" size="2">Date/Time Responded:</font><br />');
print ("$variable27 @ $variable28 $variable29");
print ('<br />');
print ('<font face="arial" size="2">Date/Time Resolved:</font><br />');
print ("$variable30 @ $variable31 $variable32");
print ('<br />');
print ('<font face="arial" size="2">Date/Time Scheduled:</font><br />');
print ("$variable33 @ $variable34 $variable35");
print ('<br />');
print ('</td>');
print ('</tr>');
print ('</table>');
//End STF Date/Time

print ('</tr>');
print ('</table>');
//End Inner Table 3

print ('</td>');
print ('</tr>');
print ('</table>');
//End STF Main Table 1 STF Information

print ('</td>');
print ('</tr>');
print ('<tr>');
print ('<td>');

//Begin STF Main Table 2 STF Service Description
print ('<table align="left" valign="top" width="650">');
print ('<tr>');
print ('<td style="border: thin black solid;" valign="top">');

//Begin Service Description Table
print ('<table width="640">');
print ('<tr>');
print ('<td>');
print ('<font face="arial" size="2">Service Description</font>');
print ('</td>');
print ('</tr>');
print ('<tr>');
print ('<td width="210" style="border: 1px black solid;" valign="top">');
print ('<font face="arial" size="2">System:</font><br />');
print ("$variable36");
print ('<br />');
print ("$variable37");
print ('<br />');
print ('</td>');
print ('<td width="210" style="border: 1px black solid;" valign="top">');
print ('<font face="arial" size="2">Component:</font><br />');
print ("$variable38");
print ('<br />');
print ("$variable39");
print ('<br />');
print ('</td>');
print ('<td width="210" style="border: 1px black solid;" valign="top">');
print ('<font face="arial" size="2">Revision:</font><br />');
print ("$variable40");
print ('<br />');
print ('<font face="arial" size="2">Anticipated Global Effects:</font><br />');
print ("$variable41");
print ('<br />');
print ('</td>');
print ('</tr>');
print ('</table>');
print ('<table width="640">');
print ('<tr>');
print ('<td width="100%">');
print ('<font face="arial" size="2">Service Description Information:</font><br />');
print ('<br />');
print ("$variable42");
print ('</td>');
print ('</tr>');
print ('</table>');
print ('</td>');
print ('</tr>');
print ('</table>');
//End STF Main Table 2 STF Service Description

print ('</td>');
print ('</tr>');
print ('<tr>');
print ('<td>');

//Begin STF Main Table 3 STF Service Resolution
print ('<table align="left" valign="top" width="650">');
print ('<tr>');
print ('<td style="border: thin black solid;" valign="top">');

//Begin Service Resolution Table
print ('<table width="640">');
print ('<tr>');
print ('<td>');
print ('<font face="arial" size="2">Service Resolution</font>');
print ('</td>');
print ('</tr>');
print ('<tr>');
print ('<td width="210" style="border: 1px black solid;" valign="top">');
print ('<font face="arial" size="2">System:</font><br />');
print ("$variable43");
print ('<br />');
print ("$variable44");
print ('<br />');
print ('</td>');
print ('<td width="210" style="border: 1px black solid;" valign="top">');
print ('<font face="arial" size="2">Component:</font><br />');
print ("$variable45");
print ('<br />');
print ("$variable46");
print ('<br />');
print ('</td>');
print ('<td width="210" style="border: 1px black solid;" valign="top">');
print ('<font face="arial" size="2">Revision:</font><br />');
print ("$variable47");
print ('<br />');
print ('</td>');
print ('</tr>');
print ('</tabled>');
print ('<table width="640">');
print ('<tr>');
print ('<td width="100%">');
print ('<font face="arial" size="2">Service Resolution Information:</font><br />');
print ('<br />');
print ("$variable48");
print ('</td>');
print ('</tr>');
print ('</table>');
print ('</td>');
print ('</tr>');
print ('</table>');
//End STF Main Table 3 STF Service Resolution

print ('</td>');
print ('</tr>');

print ('</td>');
print ('</tr>');
}

//below this is the function for no record!!
if (!$variable1)
{
print ("$XX");
}

//end
?>
</table>
<!-- //End Master Table -->
<?php
?>

Sorry for all the code and everything. Just wanted to show the scale of this project I am working on.

As I said above, I want to be able to use another HTML form to search and populate another STF html form to update and replace the old information in the database.

For your convenience I've also uploaded the four files in a ZIP file.
http://www.daniweb.com/forums/attachment.php?attachmentid=6475&stc=1&d=1214841400

Any help would be greatly appreciated.

Thank you again and God bless,
Johnathan

All,

OK so I've created my search form and it works fine. It populates most of the fields with the correct information from the MySQL DB. Now I only have two problems... how to replace the correct record on the DB and how to populate the <select></select> fields with the MySQL information in the HTML form.

Any ideas?

God bless,
Johnathan

OK, I've corrected the < select > field problem... now, how do I replace the correct record in the mysql database.

I have the folllowing code thus far for the updatestfdb.php file which takes the info from the form to the DB.

<?php
$con = mysql_connect("localhost","stf","stf"); //Replace with your actual MySQL DB Username and Password
if (!$con) 
{ 
die('Could not connect to the ASDTSG database: ' . mysql_error()); 
} 
mysql_select_db("asdtsg", $con); //Replace with your MySQL DB Name
$contactname=mysql_real_escape_string($_POST['contactname']); //This value has to be the same as in the HTML form file  //This value has to be the same as in the HTML form file
$contactphone1=mysql_real_escape_string($_POST['contactphone1']); //This value has to be the same as in the HTML form file
$contactphone2=mysql_real_escape_string($_POST['contactphone2']); //This value has to be the same as in the HTML form file
$contactfax=mysql_real_escape_string($_POST['contactfax']); //This value has to be the same as in the HTML form file
$contactaffiliation=mysql_real_escape_string($_POST['contactaffiliation']); //This value has to be the same as in the HTML form file
$contactemail=mysql_real_escape_string($_POST['contactemail']); //This value has to be the same as in the HTML form file
$contactmethod=mysql_real_escape_string($_POST['contactmethod']); //This value has to be the same as in the HTML form file
other fields...

$sql="UPDATE stf SET (contactname, contactphone1, contactphone2, contactfax, contactaffiliation, contactemail, contactmethod, other fields...) = VALUES ('$contactname', '$contactphone1', '$contactphone2', '$contactfax', '$contactaffiliation', '$contactemail', '$contactmethod', 'other fields...')"; 

if (!mysql_query($sql,$con)) {
die('Error: ' . mysql_error()); 
} 
echo "The STF that you've modified was successfully added to the database."; 
mysql_close($con);
?>

God bless and thank you,
Johnathan

Helloo..
k.Thats fine...
Tel, how did you get your record from database means by using one id,you was getting the records from db to update now,by using that id ,you can update your record now...
Using where clause in update query...

ANy doubt tel me...

Shanti and everyone else,

OK, I've actually gotten several of my problems corrected.

I've correct any HTML and PHP form. I am able to submit and retrieve forms, I can even update, the problem... is that ALL forms are updated instead of just a single form.

Here is the PHP file that displays the form that I search for:

updatestf.php

<?php
include('dbconnect.php');
//Credentials for the MySQL Database
//$hostname = "localhost"; // Our DB server.
//$username = "stf"; // The username you created for this database.
//$password = "stf"; // The password you created for the username.
//$usertable = "stf"; // The name of the table you made.
//$dbName = "asdtsg"; // This is the name of the database you made.

//Connect to the STF MySQL Database
//MYSQL_CONNECT($hostname, $username, $password) OR DIE("Unable to connect to the Database. Please make sure that your username/password/DB name and host are correct.<br />Also, make sure that the database can be accessed. You can test this by going to the following link: <a href='http://asdtsg.com/dbtest.php'>http://asdtsg.com/dbtest.php</a>.");
//@mysql_select_db( "$dbName") or die("Unable to select database. Please verify that the database name is correct.");

//query details table begins
$query = mysql_query("SELECT * FROM stf WHERE $fieldname1 LIKE '%$criteria1%'"."AND $fieldname2 LIKE '%$criteria2%'"."ORDER BY site, stfno, datereceived, timereceived, dateresolved, timeresolved");
//$query = mysql_query("SELECT * FROM stf WHERE $metode LIKE '%$search%' LIMIT 0, 50");
while ($row = @mysql_fetch_array($query))
{
$variable999=$row["id"];
$variable1=$row["contactname"];
$variable2=$row["contactphone1"];
$variable3=$row["contactphone2"];
$variable4=$row["contactfax"];
$variable5=$row["contactaffiliation"];
$variable6=$row["contactemail"];
$variable7=$row["contactmethod"];
$variable8=$row["site"];
$variable9=$row["wpn"];
$variable10=$row["sitestatus"];
$variable11=$row["accountmanagerlist"];
$variable12=$row["accountmanagernotlisted"];
$variable13=$row["submitterlist"];
$variable14=$row["submitternotlisted"];
$variable15=$row["assignedengineerlist"];
$variable16=$row["assignedengineernotlisted"];
$variable17=$row["servicecategorylist"];
$variable18=$row["stfno"];
$variable19=$row["edfno"];
$variable20=$row["erno"];
$variable21=$row["stfstatus"];
$variable22=$row["edfstatus"];
$variable23=$row["turnoverstatus"];
$variable24=$row["datereceived"];
$variable25=$row["timereceived"];
$variable26=$row["ampmreceived"];
$variable27=$row["dateresponded"];
$variable28=$row["timeresponded"];
$variable29=$row["ampmresponded"];
$variable30=$row["dateresolved"];
$variable31=$row["timeresolved"];
$variable32=$row["ampmresolved"];
$variable33=$row["datescheduled"];
$variable34=$row["timescheduled"];
$variable35=$row["ampmscheduled"];
$variable36=$row["servicedescsystemlist"];
$variable37=$row["servicedescsystemnotlisted"];
$variable38=$row["servicedesccomponentlist"];
$variable39=$row["servicedesccomponentnotlisted"];
$variable40=$row["servicedescrevision"];
$variable41=$row["anticipatedglobaleffect"];
$variable42=$row["servicedescriptioninformation"];
$variable43=$row["serviceressystemlist"];
$variable44=$row["serviceressystemnotlisted"];
$variable45=$row["servicerescomponentlist"];
$variable46=$row["servicerescomponentnotlisted"];
$variable47=$row["serviceresrevision"];
$variable48=$row["serviceresolutioninformation"];
?>
<html>
<head>
<title>Service Tracking Form</title>

<script language="JavaScript" type="text/JavaScript">
function checkForm(thisform)
{

// First check the required fields.

if(document.stf.contactname.value=='')
{
alert("The Contact Name is a required field!");
return false;
}
if(document.stf.contactemail.value=='')
{
alert("The Contact Email is a required field!");
return false;
}
if(document.stf.contactaffiliation.value=='')
{
alert("The Contact Affiliation is a required field!");
return false;
}
if(document.stf.contactmethod.value=='')
{
alert("The Contact Method is a required field!");
return false;
}
if(document.stf.site.value=='')
{
alert("The Site is a required field!");
return false;
}
if(document.stf.wpn.value=='')
{
alert("The WPN is a required field!");
return false;
}
if(document.stf.sitestatus.value=='')
{
alert("The Site Status is a required field!");
return false;
}
if(document.stf.accountmanagerlist.value=='')
{
alert("The Account Manager is a required field! If the Name is not listed please choose 'See Below' and enter the AM's name in the field below the drop down list.");
return false;
}
if(document.stf.submitterlist.value=='')
{
alert("The Sumitter is a required field! If the name is not listed please choose 'See Below' and enter the name in the field below the drop down list.");
return false;
}
if(document.stf.assignedengineerlist.value=='')
{
alert("The Assigned Engineer is a required field! If the name is not listed please choose 'See Below' and enter the name in the field below the drop down list.");
return false;
}
if(document.stf.servicecategorylist.value=='')
{
alert("The Service Category is a required field!");
return false;
}
if(document.stf.stfno.value=='')
{
alert("The STF Number is a required field!");
return false;
}
if(document.stf.stfstatus.value=='')
{
alert("The STF Status is a required field!");
return false;
}
if(document.stf.edfstatus.value=='')
{
alert("The EDF Status is a required field!");
return false;
}
if(document.stf.turnoverstatus.value=='')
{
alert("The Turn Over Status is a required field!");
return false;
}
if(document.stf.datereceived.value=='')
{
alert("The Date Received is a required field!");
return false;
}
if(document.stf.timereceived.value=='')
{
alert("The Time Received is a required field!");
return false;
}
if(document.stf.ampmreceived.value=='')
{
alert("The Time AM/PM Received is a required field!");
return false;
}
if(document.stf.dateresponded.value=='')
{
alert("The Date Responded is a required field!");
return false;
}
if(document.stf.timeresponded.value=='')
{
alert("The Time Responded is a required field!");
return false;
}
if(document.stf.ampmresponded.value=='')
{
alert("The Time AM/PM Responded is a required field!");
return false;
}
if(document.stf.dateresolvedvalue=='')
{
alert("The Date Resolved is a required field!");
return false;
}
if(document.stf.timeresolved.value=='')
{
alert("The Time Resolved is a required field!");
return false;
}
if(document.stf.ampmresolved.value=='')
{
alert("The Time AM/PM Resolved is a required field!");
return false;
}
if(document.stf.servicedescsystemlist.value=='')
{
alert("The Service Description System is a required field! If the system is not listed please choose 'See Below' and enter the system in the field below the drop down list.");
return false;
}
if(document.stf.servicedesccomponentlist.value=='')
{
alert("The Service Description Component is a required field! If the component is not listed please choose 'See Below' and enter the component in the field below the drop down list.");
return false;
}
if(document.stf.servicedescriptioninformation.value=='')
{
alert("The Service Description Information is a required field!");
return false;
}
if(document.stf.serviceresolutioninformation.value=='')
{
alert("The Service Resolution Information is a required field!");
return false;
}
if(document.stf.serviceressystemlist.value=='')
{
alert("The Service Resolution System is a required field! If the system is not listed please choose 'See Below' and enter the system in the field below the drop down list.");
return false;
}
if(document.stf.servicerescomponentlist.value=='')
{
alert("The Service Resolution Component is a required field! If the component is not listed please choose 'See Below' and enter the component in the field below the drop down list.");
return false;
}

chosen = ""
len = document.stf.stfstatus.length;
 
for(i=0;i<len;i++){
 if(document.stf.stfstatus[i].checked){
  chosen = document.stf.stfstatus[i].value;
 }
}
 
if(chosen ==""){
  alert("The STF Status is a required field! Please choose whether the STF is Opened or Closed.");
  return false;
}

chosen = ""
len = document.stf.edfstatus.length;
 
for(i=0;i<len;i++){
 if(document.stf.edfstatus[i].checked){
  chosen = document.stf.edfstatus[i].value;
 }
}
 
if(chosen ==""){
  alert("The EDF Status is a required field! Please choose whether an EDF Status is Opened or Closed.");
return false;
}

chosen = ""
len = document.stf.turnoverstatus.length;
 
for(i=0;i<len;i++){
 if(document.stf.turnoverstatus[i].checked){
  chosen = document.stf.turnoverstatus[i].value;
 }
}
 
if(chosen ==""){
  alert("The Turn Over Status is a required field! Please choose whether the site has been turnec over to the Technical Services Group or not.");
return false;
}

return true;
}
</script>

</head>
<body>
<center><font face='arial'>Please note: You will have to refill in the STF Status, EDF Status and the Turnover Status radio options.</font>


<br style="page-break-before: always" />

<form name="stf" method="POST" action="http://asdtsg.com/updatestfdb.php" 
    onsubmit="return checkForm();" style="height: 43px; width: 624px">
    
<input type="hidden" VALUE="$variable999" NAME="id">

<!-- Begin Master Table -->
<table align="left" valign="top" width="650">
<!-- Begin Master Row 1 -->
<tr>
<!-- Begin Master Cell 1 -->
<td>

<!-- Begin STF Main Table 1 (STF Information) -->
<table align="left" valign="top" width="650">
<tr>
<td style="border: thin black solid;" valign="top">

<!-- Begin Inner Table 1 -->
<table align="left" width="26%">
<tr>

<!-- Begin STF Logo -->
<td valign="top" style="border: 1px black solid;">
<center>
<img src="http://asdtsg.com/images/stories/ARINC%20logo.jpg"><br />
<font face="arial" size="4">
Service Tracking<br />
Form</font>
</center>
</td>
<!-- End STF Logo -->

</tr>
<tr>

<!-- Start STF Contact -->
<td style="border: black solid 1px;">
<font face="arial" size="2">Contact Name:</font><br />
<input type="text" size="18" name="contactname" maxlength="100" value="<?php print ("$variable1"); ?>" /><br />
<font face="arial" size="2">Contact Phone Number 1:</font><br />
<input type="text" size="18" name="contactphone1" maxlength="100" value="<?php print ("$variable2"); ?>" /><br />
<font face="arial" size="2">Contact Phone Number 2:</font><br />
<input type="text" size="18" name="contactphone2" maxlength="100" value="<?php print ("$variable3"); ?>" /><br />
<font face="arial" size="2">Contact Fax Number:</font><br />
<input type="text" size="18" name="contactfax" maxlength="100" value="<?php print ("$variable4"); ?>" /><br />
<font face="arial" size="2">Contact Affiliation:</font><br />
<select name="contactaffiliation">
<option value="<?php echo ("$variable5") ?>"><?php echo ("$variable5") ?></option> 
<option value =""></option> 
<option value ="ARINC Personnel">ARINC Personnel</option> 
<option value ="Airline Personnel">Airline Personnel</option> 
<option value ="Airport Personnel">Airport Personnel</option> 
<option value ="AFL">AFL</option> 
<option value ="AMS">AMS</option> 
<option value ="ASA">ASA</option> 
<option value ="Ascent">Ascent</option> 
<option value ="BAGS">BAGS</option> 
<option value ="BAR">BAR</option> 
<option value ="Blackhawk Systems">Blackhawk Systems</option> 
<option value ="Citrix Systems Inc.">Citrix Systems Inc.</option> 
<option value ="CSI">CSI</option> 
<option value ="Damarel">Damarel</option> 
<option value ="EDS">EDS</option> 
<option value ="ESP">ESP</option> 
<option value ="FASL">FASL</option> 
<option value ="Fujitsu">Fujitsu</option> 
<option value ="GigaNet">GigaNet</option> 
<option value ="IBM">IBM</option> 
<option value ="IBS">IBS</option> 
<option value ="ICT">ICT</option> 
<option value ="IDS">IDS</option> 
<option value ="IER">IER</option> 
<option value ="Intelisys">Intelisys</option> 
<option value ="Intermec">Intermec</option> 
<option value ="JIT">JIT</option> 
<option value ="Kinetics">Kinetics</option> 
<option value ="Lufthansa Systems">Lufthansa Systems</option> 
<option value ="Menzies Aviation">Menzies Aviation</option> 
<option value ="MPHASIS">MPHASIS</option> 
<option value ="Navitaire">Navitaire</option> 
<option value ="GLOGIC">QLOGIC</option> 
<option value ="Sabre">Sabre</option> 
<option value ="SITA">SITA</option> 
<option value ="ServiceTec">ServiceTec</option> 
<option value ="Travsys">Travsys</option> 
<option value ="Ultra">Ultra</option> 
<option value ="UNISYS">UNISYS</option> 
<option value ="Vidtronix">Vidtronix</option> 
<option value ="Other">Other</option> 
</select><br />
<font face="arial" size="2">Contact Email:</font><br />
<input type="text" size="18" name="contactemail" maxlength="100" value="<?php print ("$variable6"); ?>" /><br />
<font face="arial" size="2">Contact Method:</font><br />
<select name="contactmethod">
<option value="<?php echo ("$variable7") ?>"><?php echo ("$variable7") ?></option> 
<option value =""></option>
<option value ="ais_support@arinc.com">ais_support@arinc.com</option>
<option value ="Hotline">Hotline</option>
<option value ="Internal Identification">Internal Identification</option>
<option value ="Office Email">Office Email</option>
<option value ="Office Phone Call">Office Phone Call</option>
</select>
</td>
<!-- End STF Contact -->

</tr>
</table>
<!-- End Inner Table 1 -->

<!-- Begin Inner Table 2 -->
<table align="left" width="36%">
<tr>

<!-- Begin STF Site -->
<td  style="border: 1px black solid;">
<font face="arial" size="2">Site:</font><br />
<input type="text" size="2" name="site" maxlength="3"  onBlur="javascript:this.value=this.value.toUpperCase();" value="<?php print ("$variable8"); ?>" /><br />
<font face="arial" size="2">WPN:</font><br />
<input type="text" size="18" name="wpn" value="<?php print ("$variable9"); ?>"/><br />
<font face="arial" size="2">Site Status:</font><br />
<select name="sitestatus">
<option value="<?php echo ("$variable10") ?>"><?php echo ("$variable10") ?></option> 
<option value =""></option>
<option value ="All">All</option>
<option value ="Airport Systems Division (ASD)">Airport Systems Division (ASD)</option>
<option value ="Asia Pacific Division (APD)">Asia Pacific Division (APD)</option>
<option value ="Europe Middle East Africa (EMEA)">Europe Middle East Africa (EMEA)</option>
</select><br />
<font face="arial" size="2">Account Manager:</font><br />
<select name="accountmanagerlist">
<option value="<?php echo ("$variable11") ?>"><?php echo ("$variable11") ?></option> 
<option value =""></option>
<option value ="All">All</option>
<option value ="----------APD----------">----------APD----------</option>
<option value ="Allen Olano">Allen Olano</option>
<option value ="Glen Oliveiro">Glen Oliveiro</option>
<option value ="Koichi Mikami">Koichi Mikami</option>
<option value ="Sabrina Lai">Sabrina Lai</option>
<option value ="Willy Kim">Willy Kim</option>
<option value ="Yoshiyuki Tawara">Yoshiyuki Tawara</option>
<option value ="----------ASD----------">----------ASD----------</option>
<option value ="Carmen Corraro">Carmen Corraro</option>
<option value ="Grant Decker">Grant Decker</option>
<option value ="Jeff Byers">Jeff Byers</option>
<option value ="John Dungan">John Dungan</option>
<option value ="Marian Bracho">Marian Bracho</option>
<option value ="Salley Philpott">Salley Philpott</option>
<option value ="Tawnya Templeton">Tawnya Templeton</option>
<option value ="Tony Blockton">Tony Blockton</option>
<option value ="---------EMEA---------">---------EMEA---------</option>
<option value ="Carlos Jodar">Carlos Jodar</option>
<option value ="Chris Young">Chris Young</option>
<option value ="Debra Lawrence">Debra Lawrence</option>
<option value ="James Needham">James Needham</option>
<option value ="Linda Judge">Linda Judge</option>
<option value ="Mahira Khan">Mahira Khan</option>
<option value ="Marco Delu">Marco Delu</option>
<option value ="Melanie Reiser">Melanie Reiser</option>
<option value ="Peter Webb">Peter Webb</option>
<option value ="Rob Debruijn">Rob Debruijn</option>
<option value ="Robin Santall">Robin Santall</option>
<option value ="Stefano Boccafoglia">Stefano Boccafoglia</option>
<option value ="Taania Hobden">Taania Hobden</option>
<option value ="Tracey Atkinson">Tracey Atkinson</option>
<option value ="---------Other---------">---------Other---------</option>
<option value ="See Below">See Below</option>
</select><br />
<input type="text" size="18" name="accountmanagernotlisted" value="<?php print ("$variable12"); ?>"/><br />
</td>
<!-- End STF Site -->

</tr>
<tr>

<!-- Begin STF Submitter -->
<td align="left" valign="top"  style="border: 1px black solid;">
<font face="arial" size="2">Submitter:</font><br />
<select name="submitterlist">
<option value="<?php echo ("$variable13") ?>"><?php echo ("$variable13") ?></option> 
<option value =""></option>
<option value ="Aaron Downing">Aaron Downing</option>
<option value ="Ercan Kadakal">Ercan Kadakal</option>
<option value ="Greg Gatz">Greg Gatz</option>
<option value ="Johnathan Morlock">Johnathan Morlock</option>
<option value ="Matt Sirkis">Matt Sirkis</option>
<option value ="Patrick Hicks">Patrick Hicks</option>
<option value ="Stephen Khan">Stephen Khan</option>
<option value ="---------Other---------">---------Other---------</option>
<option value ="See Below">See Below</option>
</select><br />
<input type="text" size="18" name="submitternotlisted" value="<?php print ("$variable14"); ?>"/><br />
<font face="arial" size="2">Assigned Engineer:</font><br />
<select name="assignedengineerlist">
<option value="<?php echo ("$variable15") ?>"><?php echo ("$variable15") ?></option> 
<option value =""></option>
<option value ="Aaron Downing">Aaron Downing</option>
<option value ="Ercan Kadakal">Ercan Kadakal</option>
<option value ="Greg Gatz">Greg Gatz</option>
<option value ="Johnathan Morlock">Johnathan Morlock</option>
<option value ="Matt Sirkis">Matt Sirkis</option>
<option value ="Patrick Hicks">Patrick Hicks</option>
<option value ="Stephen Khan">Stephen Khan</option>
<option value ="---------Other---------">---------Other---------</option>
<option value ="See Below">See Below</option>
</select><br />
<input type="text" size="18" name="assignedengineernotlisted" value="<?php print ("$variable16"); ?>"/>
</td>
<!-- End STF Submitter -->

</tr>
<tr>

<!-- Start Issue Info -->
<td style="border: black solid 1px;" align="left">
<font face="arial" size="2">Service Category</font><br />
<select name="servicecategorylist">
<option value="<?php echo ("$variable17") ?>"><?php echo ("$variable17") ?></option> 
<option value =""></option>
<option value ="ARINC Software">ARINC Software</option>
<option value ="Circuit Error">Circuit Error</option>
<option value ="Configuration Change">Configuration Change</option>
<option value ="Configuration Error">Configuration Error</option>
<option value ="Hardware Error">Hardware Error</option>
<option value ="Host Error">Host Error</option>
<option value ="Information Request">Information Request</option>
<option value ="Network Error">Network Error</option>
<option value ="Power Outage">Power Outage</option>
<option value ="Software Deployment">Software Deployment</option>
<option value ="Software Upgrade">Software Upgrade</option>
<option value ="Third-Party Software">Third-Party Software</option>
<option value ="User Error">User Error</option>
<option value ="Unknown">Unknown</option>
<option value ="Other">Other</option>
</select><br />
</td>
<!-- End Issue Info -->

</tr>
</table>
<!-- End Inner Table 2 -->

<!-- Begin Inner Table 3 -->
<table align="left" width="35%" valign="top">
<tr>
<td style="border: 1px black solid">

<!-- Begin STF No. -->
<table>
<tr>
<td align="left" valign="top">
<font face="arial" size="2">STF No.:</font><br />
<!-- Applied the Numbers Only javascript to this input. -->
<input type="text" size="10" name="stfno" maxlength="8" onkeyup="this.value = this.value.replace (/\D+/, '')" value="<?php print ("$variable18"); ?>" /><br />
<font face="arial" size="2">EDF No.:</font><br />
<input type="text" size="10" name="edfno" maxlength="20" value="<?php print ("$variable19"); ?>" /><br />
<font face="arial" size="2">Ext. Ref. No.:</font><br />
<input type="text" size="10" name="erno" maxlength="20" value="<?php print ("$variable20"); ?>" />
</td>
<!-- End STF No. -->

<!-- Begin STF Status -->
<td align="left" valign="top">
<table width="100%">
<tr>
<td>
<font face="arial" size="2">STF Status:</font><br />
</td>
</tr>
</table>
<table>
<tr>
<td>
<input type="radio" name="stfstatus" value="Open" />
<font face="arial" size="1">Open</font>
</td>
<td>
<input type="radio" name="stfstatus" value="Closed" />
<font face="arial" size="1">Closed</font>
</td>
</tr>
</table>
<table width="100%">
<tr>
<td>
<font face="arial" size="2">EDF Status:</font><br />
</td>
</tr>
</table>
<table>
<tr>
<td>
<input type="radio" name="edfstatus" value="Open" />
<font face="arial" size="1">Open</font>
</td>
<td>
<input type="radio" name="edfstatus" value="Closed" />
<font face="arial" size="1">Closed</font>
</td>
</tr>
</table>
<table width="100%">
<tr>
<td>
<font face="arial" size="2">Turn Over Status:</font><br />
</td>
</tr>
</table>
<table>
<tr>
<td>
<input type="radio" name="turnoverstatus" value="Yes" />
<font face="arial" size="1">Yes</font>
</td>
<td>
<input type="radio" name="turnoverstatus" value="No" />
<font face="arial" size="1">No</font>
</td>
</tr>
</table>
</td>
</tr>
</table>
<!-- End STF Status -->

</td>
</tr>
<tr>
<td style="border: 1px black solid">

<!-- Begin STF Date/Time -->
<table>
<tr>
<td>
<font face="arial" size="2">Date/Time Received:</font><br />
<input name="datereceived" type="text" size="6" maxlength="10" value="<?php print ("$variable24"); ?>" /> @ <input name="timereceived" type="text" size="6" maxlength="5" value="<?php print ("$variable25"); ?>" /><select name="ampmreceived"><option value="<?php echo ("$variable26") ?>"><?php echo ("$variable26") ?></option> <option value =""></option><option value ="AM">AM</option><option value ="PM">PM</option></select><br />
<font face="arial" size="2">Date/Time Responded:</font><br />
<input name="dateresponded" type="text" size="6" maxlength="10" value="<?php print ("$variable27"); ?>" /> @ <input name="timeresponded" type="text" size="6" maxlength="5" value="<?php print ("$variable28"); ?>" /><select name="ampmresponded"><option value="<?php echo ("$variable29") ?>"><?php echo ("$variable29") ?></option> <option value =""></option><option value ="AM">AM</option><option value ="PM">PM</option></select><br />
<font face="arial" size="2">Date/Time Resolved:</font><br />
<input name="dateresolved" type="text" size="6" maxlength="10" value="<?php print ("$variable30"); ?>" /> @ <input name="timeresolved" type="text" size="6" maxlength="5" value="<?php print ("$variable31"); ?>" /><select name="ampmresolved"><option value="<?php echo ("$variable32") ?>"><?php echo ("$variable32") ?></option> <option value =""></option><option value ="AM">AM</option><option value ="PM">PM</option></select><br />
<font face="arial" size="2">Date/Time Scheduled:</font><br />
<input name="datescheduled" type="text" size="6" maxlength="10" value="<?php print ("$variable33"); ?>" /> @ <input name="timescheduled" type="text" size="6" maxlength="5" value="<?php print ("$variable34"); ?>" /><select name="ampmscheduled"><option value="<?php echo ("$variable35") ?>"><?php echo ("$variable35") ?></option> <option value =""></option><option value ="AM">AM</option><option value ="PM">PM</option></select><br />
</td>
</tr>
</table>
<!-- End STF Date/Time -->

</tr>
</table>
<!-- End Inner Table 3 -->

</td>
</tr>
</table>
<!-- End STF Main Table 1 (STF Information) -->

</br>

</td>
<!-- End Master Cell 1 -->
</tr>
<!-- End Master Row 1 -->
<!-- Begin Master Row 2 -->
<tr>
<!-- Begin Master Cell 2 -->
<td>

<!-- Begin STF Main Table 2 (STF Service Description) -->
<table align="left" valign="top" width="650">
<tr>
<td style="border: thin black solid;" valign="top">

<!-- Begin Service Description Table -->
<table width="99%">
<tr>
<td width="100%">
<font face="arial" size="2">Service Description</font>
</td>
</tr>
<tr>
<td width="32%" style="border: 1px black solid;" valign="top">
<font face="arial" size="2">System:</font><br />
<select name="servicedescsystemlist">
<option value="<?php echo ("$variable36") ?>"><?php echo ("$variable36") ?></option> 
<option value =""></option>
<option value ="AODB">AODB</option>
<option value ="BRS">BRS</option>
<option value ="CUSS">CUSS</option>
<option value ="FIDS">FIDS</option>
<option value ="iMuse">iMuse</option>
<option value ="MUSE/NT">MUSE/NT</option>
<option value ="RPS">RPS</option>
<option value ="Security">Security</option>
<option value ="vMuse">vMuse</option>
<option value ="---------Other---------">---------Other---------</option>
<option value ="See Below">See Below</option>
</select><br />
<input name="servicedescsystemnotlisted" type="text" size="29" value="<?php print ("$variable37"); ?>" />
</td>
<td width="32%" style="border: 1px black solid;" valign="top">
<font face="arial" size="2">Component:</font><br />
<select name="servicedesccomponentlist">
<option value="<?php echo ("$variable38") ?>"><?php echo ("$variable38") ?></option> 
<option value =""></option>
<option value ="AirDB">AirDB</option>
<option value ="AirVue">AirVue</option>
<option value ="ATTS">ATTS</option>
<option value ="AVRS">AVRS</option>
<option value ="Babel">Babel</option>
<option value ="BagLink">BagLink</option>
<option value ="BDCS">BDCS</option>
<option value ="EasyCheck">EasyCheck</option>
<option value ="GateFlow">GateFlow</option>
<option value ="IDMS">IDMS</option>
<option value ="iMuse Express">iMuse Express</option>
<option value ="InfoHub">InfoHub</option>
<option value ="LBA2">LBA2</option>
<option value ="LDCS">LDCS</option>
<option value ="LodeStone">LodeStone</option>
<option value ="Onvoy">Onvoy</option>
<option value ="Tagtrak">Tagtrak</option>
<option value ="Vanguards">Vanguard</option>
<option value ="---------Other---------">---------Other---------</option>
<option value ="See Below">See Below</option>
</select><br />
<input name="servicedesccomponentnotlisted" type="text"  size="29" value="<?php print ("$variable39"); ?>" />
</td>
<td width="32%" style="border: 1px black solid;" valign="top">
<font face="arial" size="2">Revision:</font><br />
<input name="servicedescrevision" type="text" size="29" value="<?php print ("$variable40"); ?>" /><br />
<font face="arial" size="2">Anticipated Global Effects:</font><br />
<input name="anticipatedglobaleffect" type="text" size="29" value="<?php print ("$variable41"); ?>" /><br />
</td>
</tr>
</table>
<table width="100%">
<tr>
<td width="100%">
<font face="arial" size="2">Service Description Information:</font><br />
<center>
<textarea name="servicedescriptioninformation" cols="73" rows="20"><?php print ("$variable42"); ?></textarea>
</center>
</td>
</tr>
</table>
</td>
</tr>
</table>
<!-- End STF Main Table 2 (STF Service Description) -->

</td>
<!-- End Master Cell 2 -->
</tr>
<!-- End Master Row 2 -->
<!-- Begin Master Row 3 -->
<tr>
<!-- Begin Master Cell 3 -->
<td>

<!-- Begin STF Main Table 3 (STF Service Resolution) -->
<table align="left" valign="top" width="650">
<tr>
<td style="border: thin black solid;" valign="top">

<!-- Begin Service Resolution Table -->
<table width="640">
<tr>
<td width="100%">
<font face="arial" size="2">Service Resolution</font>
</td>
</tr>
<tr>
<td width="32%" style="border: 1px black solid;" valign="top">
<font face="arial" size="2">System:</font><br />
<select name="serviceressystemlist">
<option value="<?php echo ("$variable43") ?>"><?php echo ("$variable43") ?></option> 
<option value =""></option>
<option value ="AODB">AODB</option>
<option value ="BRS">BRS</option>
<option value ="CUSS">CUSS</option>
<option value ="FIDS">FIDS</option>
<option value ="iMuse">iMuse</option>
<option value ="MUSE/NT">MUSE/NT</option>
<option value ="RPS">RPS</option>
<option value ="Security">Security</option>
<option value ="vMuse">vMuse</option>
<option value ="---------Other---------">---------Other---------</option>
<option value ="See Below">See Below</option>
</select><br />
<input name="serviceressystemnotlisted" type="text" size="29" value="<?php print ("$variable44"); ?>" />
</td>
<td width="32%" style="border: 1px black solid;" valign="top">
<font face="arial" size="2">Component:</font><br />
<select name="servicerescomponentlist">
<option value="<?php echo ("$variable45") ?>"><?php echo ("$variable45") ?></option> 
<option value =""></option>
<option value ="AirDB">AirDB</option>
<option value ="AirVue">AirVue</option>
<option value ="ATTS">ATTS</option>
<option value ="AVRS">AVRS</option>
<option value ="Babel">Babel</option>
<option value ="BagLink">BagLink</option>
<option value ="BDCS">BDCS</option>
<option value ="EasyCheck">EasyCheck</option>
<option value ="GateFlow">GateFlow</option>
<option value ="IDMS">IDMS</option>
<option value ="iMuse Express">iMuse Express</option>
<option value ="InfoHub">InfoHub</option>
<option value ="LBA2">LBA2</option>
<option value ="LDCS">LDCS</option>
<option value ="LodeStone">LodeStone</option>
<option value ="Onvoy">Onvoy</option>
<option value ="Tagtrak">Tagtrak</option>
<option value ="Vanguards">Vanguard</option>
<option value ="---------Other---------">---------Other---------</option>
<option value ="See Below">See Below</option>
</select><br />
<input name="servicerescomponentnotlisted" type="text" size="29" value="<?php print ("$variable46"); ?>" />
</td>
<td width="32%" style="border: 1px black solid;" valign="top">
<font face="arial" size="2">Revision:</font><br />
<input name="serviceresrevision" type="text" size="29" value="<?php print ("$variable47"); ?>" /><br />
</td>
</tr>
</table>
<table width="100%">
<tr>
<td width="100%">
<font face="arial" size="2">Service Resolution Information:</font><br />
<center>
<textarea name="serviceresolutioninformation" cols="73" rows="20"><?php print ("$variable48"); ?></textarea>
</center>
</td>
</tr>
</table>
<input type="submit" name="submit" value="Submit STF"  /><input type="reset" value="Reset STF">
</td>
</tr>
</table>
<!-- End STF Main Table 3 (STF Service Resolution) -->

</td>
<!-- End Master Cell 3 -->
</tr>
<!-- End Master Row 3 -->
</table>
<!-- End Master Table -->

</form>

</center>

</body>
</html>
<?php
}

//Error message that displays of the search come sup with nothing.
$XX = "
<center>Sorry, an STF was not found with the search criteria:<br />
<table style='border: thin solid black'>
<tr>
<td style='border: 1px solid gray'>Search Field Name:</td>
<td style='border: 1px solid gray'>Search Field Criteria:</td>
</tr>
<tr>
<td><font color='blue'>$fieldname1</font></td>
<td><font color='red'>$criteria1</font></td>
</tr>
<tr>
<td><font color='blue'>$fieldname2</font></td>
<td><font color='red'>$criteria2</font></td>
</tr>
</table><br />
Please close this window and try again.</center>";

//below this is the function for no record!!
if (!$variable1)
{
print ("$XX");
}

//end
?>

Here is the PHP file that sends the update information to the DB:

updatestfdb.php

<?php
$con = mysql_connect("localhost","stf","stf"); //Replace with your actual MySQL DB Username and Password
if (!$con) 
{ 
die('Could not connect to the ASDTSG database: ' . mysql_error()); 
} 
mysql_select_db("asdtsg", $con); //Replace with your MySQL DB Name
$id=($_GET['id']);
$contactname=mysql_real_escape_string($_POST['contactname']); //This value has to be the same as in the HTML form file  //This value has to be the same as in the HTML form file
$contactphone1=mysql_real_escape_string($_POST['contactphone1']); //This value has to be the same as in the HTML form file
$contactphone2=mysql_real_escape_string($_POST['contactphone2']); //This value has to be the same as in the HTML form file
$contactfax=mysql_real_escape_string($_POST['contactfax']); //This value has to be the same as in the HTML form file
$contactaffiliation=mysql_real_escape_string($_POST['contactaffiliation']); //This value has to be the same as in the HTML form file
$contactemail=mysql_real_escape_string($_POST['contactemail']); //This value has to be the same as in the HTML form file
$contactmethod=mysql_real_escape_string($_POST['contactmethod']); //This value has to be the same as in the HTML form file
$site=mysql_real_escape_string($_POST['site']); //This value has to be the same as in the HTML form file
$wpn=mysql_real_escape_string($_POST['wpn']); //This value has to be the same as in the HTML form file
$sitestatus=mysql_real_escape_string($_POST['sitestatus']); //This value has to be the same as in the HTML form file
$accountmanagerlist=mysql_real_escape_string($_POST['accountmanagerlist']); //This value has to be the same as in the HTML form file
$accountmanagernotlisted=mysql_real_escape_string($_POST['accountmanagernotlisted']); //This value has to be the same as in the HTML form file
$submitterlist=mysql_real_escape_string($_POST['submitterlist']); //This value has to be the same as in the HTML form file
$submitternotlisted=mysql_real_escape_string($_POST['submitternotlisted']); //This value has to be the same as in the HTML form file
$assignedengineerlist=mysql_real_escape_string($_POST['assignedengineerlist']); //This value has to be the same as in the HTML form file
$assignedengineernotlisted=mysql_real_escape_string($_POST['assignedengineernotlisted']); //This value has to be the same as in the HTML form file
$servicecategorylist=mysql_real_escape_string($_POST['servicecategorylist']); //This value has to be the same as in the HTML form file
$stfno=mysql_real_escape_string($_POST['stfno']); //This value has to be the same as in the HTML form file
$edfno=mysql_real_escape_string($_POST['edfno']); //This value has to be the same as in the HTML form file
$erno=mysql_real_escape_string($_POST['erno']); //This value has to be the same as in the HTML form file
$stfstatus=mysql_real_escape_string($_POST['stfstatus']); //This value has to be the same as in the HTML form file
$edfstatus=mysql_real_escape_string($_POST['edfstatus']); //This value has to be the same as in the HTML form file
$turnoverstatus=mysql_real_escape_string($_POST['turnoverstatus']); //This value has to be the same as in the HTML form file
$datereceived=mysql_real_escape_string($_POST['datereceived']); //This value has to be the same as in the HTML form file
$timereceived=mysql_real_escape_string($_POST['timereceived']); //This value has to be the same as in the HTML form file
$ampmreceived=mysql_real_escape_string($_POST['ampmreceived']); //This value has to be the same as in the HTML form file
$dateresponded=mysql_real_escape_string($_POST['dateresponded']); //This value has to be the same as in the HTML form file
$timeresponded=mysql_real_escape_string($_POST['timeresponded']); //This value has to be the same as in the HTML form file
$ampmresponded=mysql_real_escape_string($_POST['ampmresponded']); //This value has to be the same as in the HTML form file
$dateresolved=mysql_real_escape_string($_POST['dateresolved']); //This value has to be the same as in the HTML form file
$timeresolved=mysql_real_escape_string($_POST['timeresolved']); //This value has to be the same as in the HTML form file
$ampmresolved=mysql_real_escape_string($_POST['ampmresolved']); //This value has to be the same as in the HTML form file
$datescheduled=mysql_real_escape_string($_POST['datescheduled']); //This value has to be the same as in the HTML form file
$timescheduled=mysql_real_escape_string($_POST['timescheduled']); //This value has to be the same as in the HTML form file
$ampmscheduled=mysql_real_escape_string($_POST['ampmscheduled']); //This value has to be the same as in the HTML form file
$servicedescsystemlist=mysql_real_escape_string($_POST['servicedescsystemlist']); //This value has to be the same as in the HTML form file
$servicedescsystemnotlisted=mysql_real_escape_string($_POST['servicedescsystemnotlisted']); //This value has to be the same as in the HTML form file
$servicedesccomponentlist=mysql_real_escape_string($_POST['servicedesccomponentlist']); //This value has to be the same as in the HTML form file
$servicedesccomponentnotlisted=mysql_real_escape_string($_POST['servicedesccomponentnotlisted']); //This value has to be the same as in the HTML form file
$servicedescrevision=mysql_real_escape_string($_POST['servicedescrevision']); //This value has to be the same as in the HTML form file
$anticipatedglobaleffect=mysql_real_escape_string($_POST['anticipatedglobaleffect']); //This value has to be the same as in the HTML form file
$servicedescriptioninformation=mysql_real_escape_string($_POST['servicedescriptioninformation']); //This value has to be the same as in the HTML form file
$serviceressystemlist=mysql_real_escape_string($_POST['serviceressystemlist']); //This value has to be the same as in the HTML form file
$serviceressystemnotlisted=mysql_real_escape_string($_POST['serviceressystemnotlisted']); //This value has to be the same as in the HTML form file
$servicerescomponentlist=mysql_real_escape_string($_POST['servicerescomponentlist']); //This value has to be the same as in the HTML form file
$servicerescomponentnotlisted=mysql_real_escape_string($_POST['servicerescomponentnotlisted']); //This value has to be the same as in the HTML form file
$serviceresrevision=mysql_real_escape_string($_POST['serviceresrevision']); //This value has to be the same as in the HTML form file
$serviceresolutioninformation=mysql_real_escape_string($_POST['serviceresolutioninformation']); //This value has to be the same as in the HTML form file

echo $sql="UPDATE stf SET contactname='$contactname', contactphone1='$contactphone1', contactphone2='$contactphone2', contactfax='$contactfax', contactaffiliation='$contactaffiliation', contactemail='$contactemail', contactmethod='$contactmethod', site='$site', wpn='$wpn', sitestatus='$sitestatus', accountmanagerlist='$accountmanagerlist', accountmanagernotlisted='$accountmanagernotlisted', submitterlist='$submitterlist', submitternotlisted='$submitternotlisted', assignedengineerlist='$assignedengineerlist', assignedengineernotlisted='$assignedengineernotlisted', servicecategorylist='$servicecategorylist', stfno='$stfno', edfno='$edfno', erno='$erno', stfstatus='$stfstatus', edfstatus='$edfstatus', turnoverstatus='$turnoverstatus', datereceived='$datereceived', timereceived='$timereceived', ampmreceived='$ampmreceived', dateresponded='$dateresponded', timeresponded='$timeresponded', ampmresponded='$ampmresponded', dateresolved='$dateresolved', timeresolved='$timeresolved', ampmresolved='$ampmresolved', datescheduled='$datescheduled', timescheduled='$timescheduled', ampmscheduled='$ampmscheduled', servicedescsystemlist='$servicedescsystemlist', servicedescsystemnotlisted='$servicedescsystemnotlisted', servicedesccomponentlist='$servicedesccomponentlist', servicedesccomponentnotlisted='$servicedesccomponentnotlisted', servicedescrevision='$servicedescrevision', anticipatedglobaleffect='$anticipatedglobaleffect', servicedescriptioninformation='$servicedescriptioninformation', serviceressystemlist='$serviceressystemlist', serviceressystemnotlisted='$serviceressystemnotlisted', servicerescomponentlist='$servicerescomponentlist', servicerescomponentnotlisted='$servicerescomponentnotlisted', serviceresrevision='$serviceresrevision', serviceresolutioninformation='$serviceresolutioninformation' WHERE id='$id'"; 

/* 'stf' is the name of the MySQL table where the form data will be saved. The names between the 1st set of ( and ) are the respective table fields. After that, all of the '$xxxx' are the related field names form the list above which are the same names within the HTML form. */

if (!mysql_query($sql,$con)) {
 die('Error: ' . mysql_error()); 
} 
echo "The STF that you've modified was successfully updated in the database."; 
mysql_close($con);
?>

As I said, the problem is updating one (1) form and not all. I've added the WHERE statement to attempt to select the ID of the form, which right now doesn't work.

Any ideas?

Thank you and God bless,
Johnathan

Oh, and sorry, here is the STF table from my DB... you can tell that all of the forms were updated at the same time:

-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jul 11, 2008 at 09:13 AM
-- Server version: 5.0.18
-- PHP Version: 5.1.2
-- 
-- Database: `asdtsg`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `stf`
-- 

CREATE TABLE `stf` (
  `id` int(11) NOT NULL auto_increment,
  `contactname` varchar(255) default NULL,
  `contactphone1` varchar(255) default NULL,
  `contactphone2` varchar(255) default NULL,
  `contactfax` varchar(255) default NULL,
  `contactaffiliation` varchar(255) default NULL,
  `contactemail` varchar(255) default NULL,
  `contactmethod` varchar(255) default NULL,
  `site` varchar(255) default NULL,
  `wpn` varchar(255) default NULL,
  `sitestatus` varchar(255) default NULL,
  `accountmanagerlist` varchar(255) default NULL,
  `accountmanagernotlisted` varchar(255) default NULL,
  `submitterlist` varchar(255) default NULL,
  `submitternotlisted` varchar(255) default NULL,
  `assignedengineerlist` varchar(255) default NULL,
  `assignedengineernotlisted` varchar(255) default NULL,
  `servicecategorylist` varchar(255) default NULL,
  `stfno` varchar(255) default NULL,
  `edfno` varchar(255) default NULL,
  `erno` varchar(255) default NULL,
  `stfstatus` varchar(255) default NULL,
  `edfstatus` varchar(255) default NULL,
  `turnoverstatus` varchar(255) default NULL,
  `datereceived` varchar(255) default NULL,
  `timereceived` varchar(255) default NULL,
  `ampmreceived` varchar(255) default NULL,
  `dateresponded` varchar(255) default NULL,
  `timeresponded` varchar(255) default NULL,
  `ampmresponded` varchar(255) default NULL,
  `dateresolved` varchar(255) default NULL,
  `timeresolved` varchar(255) default NULL,
  `ampmresolved` varchar(255) default NULL,
  `datescheduled` varchar(255) default NULL,
  `timescheduled` varchar(255) default NULL,
  `ampmscheduled` varchar(255) default NULL,
  `servicedescsystemlist` varchar(255) default NULL,
  `servicedescsystemnotlisted` varchar(255) default NULL,
  `servicedesccomponentlist` varchar(255) default NULL,
  `servicedesccomponentnotlisted` varchar(255) default NULL,
  `servicedescrevision` varchar(255) default NULL,
  `anticipatedglobaleffect` varchar(255) default NULL,
  `servicedescriptioninformation` longtext,
  `serviceressystemlist` varchar(255) default NULL,
  `serviceressystemnotlisted` varchar(255) default NULL,
  `servicerescomponentlist` varchar(255) default NULL,
  `servicerescomponentnotlisted` varchar(255) default NULL,
  `serviceresrevision` varchar(255) default NULL,
  `serviceresolutioninformation` longtext,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;

-- 
-- Dumping data for table `stf`
-- 

INSERT INTO `stf` VALUES (1, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (2, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (3, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (4, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (5, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (6, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (7, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (20, 'a', 'a', 'a', 'a', 'ARINC Personnel', 'a', 'ais_support@arinc.com', 'AAA', 'a', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Open', 'Closed', 'No', 'a', 'a', 'AM', 'a', 'a', 'AM', 'a', 'a', 'AM', 'a', 'a', 'AM', 'AODB', '', 'AirDB', '', '', '', 'aaaaa', 'AODB', '', 'AirDB', '', '', 'aaaaa');
INSERT INTO `stf` VALUES (8, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (9, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (10, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (11, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (12, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (13, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (14, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (15, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (16, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (17, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (18, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (19, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
This article has been dead for over six months. Start a new discussion instead.