[stomlin]

I have a form that I am sending to a database. However, the form is incredibly long so I would like the results split and have the first part of the form sent to one database and the second part to another table in the same database. Is this possible?

If not how do you split a form so that the user can come back and continue entering data at a later time??

[Bonzo]

Try putting two database "INSERT INTO" lines with half the form details in one and the other half in the other ?

[Bonzo]

Something strange happened - submitted twice my fault : )

Anthony

[stomlin]

This is what I have for the insert section


mysql_select_db("database_name");
$query = "insert into table01_name (LastName, FirstName, MI, Address, AptNumber, CurrentCity, CurrentState, CurrentZip, CurrentHomePhone, CurrentAltPhoneNumber, CurrentEmail, SocialSecurityNumber, DriversLicense, IssuingState) values ('".$LastName."','".$FirstName."','".$MI."','".$Ad dress."','".$AptNumber."','".$CurrentCity."','".$C urrentState."','".$CurrentZip."','".$CurrentHomePh one."','".$CurrentAltPhoneNumber."','".$CurrentEma il."','".$SocialSecurityNumber."','".$DriversLicen se."','".$IssuingState."')";

mysql_select_db("database_name");
$query = "insert into table02_name (ResidenceHistoryAddress1, ResidenceHistoryCity1, ResidenceHistoryState1, ResidenceHistoryZip1, ResidenceHistoryFrom1, ResidenceHistoryTo1, ResidenceHistoryAddrss2, ResidenceHistoryCity2, ResidenceHistoryState2, ResidenceHistoryZip2, ResidenceHistoryFrom2, ResidenceHistoryTo2, ResidenceHistoryAddrss3, ResidenceHistoryCity3, ResidenceHistoryState3, ResidenceHistoryZip3, ResidenceHistoryFrom3, ResidenceHistoryTo3, ResidenceHistoryAddrss4, ResidenceHistoryCity4, ResidenceHistoryState4, ResidenceHistoryZip4, ResidenceHistoryFrom4, ResidenceHistoryTo4, ResidenceHistoryAddrss5, ResidenceHistoryCity5, ResidenceHistoryState5, ResidenceHistoryZip5, ResidenceHistoryFrom5, ResidenceHistoryTo5, ResidenceHistoryAddrss6, ResidenceHistoryCity6, ResidenceHistoryState6, ResidenceHistoryZip6, ResidenceHistoryFrom6, ResidenceHistoryTo6) values ('".$ResidenceHistoryAddress1."','".$ResidenceHist oryCity1."','".$ResidenceHistoryState1."','".$Resi denceHistoryZip1."','".$ResidenceHistoryFrom1."',' ".$ResidenceHistoryTo1."','".$ResidenceHistoryAddr ss2."','".$ResidenceHistoryCity2."','".$ResidenceH istoryState2."','".$ResidenceHistoryZip2."','".$Re sidenceHistoryFrom2."','".$ResidenceHistoryTo2."', '".$ResidenceHistoryAddrss3."','".$ResidenceHistor yCity3."','".$ResidenceHistoryState3."','".$Reside nceHistoryZip3."','".$ResidenceHistoryFrom3."','". $ResidenceHistoryTo3."','".$ResidenceHistoryAddrss 4."','".$ResidenceHistoryCity4."','".$ResidenceHis toryState4."','".$ResidenceHistoryZip4."','".$Resi denceHistoryFrom4."','".$ResidenceHistoryTo4."','" .$ResidenceHistoryAddrss5."','".$ResidenceHistoryC ity5."','".$ResidenceHistoryState5."','".$Residenc eHistoryZip5."','".$ResidenceHistoryFrom5."','".$R esidenceHistoryTo5."','".$ResidenceHistoryAddrss6. "','".$ResidenceHistoryCity6."','".$ResidenceHisto ryState6."','".$ResidenceHistoryZip6."','".$Reside nceHistoryFrom6."','".$ResidenceHistoryTo6."')";