I have a form that is rather lengthy and I am trying to split it and have the results sent to different tables in the database. However, it isn't working......any help or pointers would be greatly appreciated.
Here is the code I am working with:
mysql_select_db("database_name");
$query = "insert into table_01 (LastName, FirstName, MI, Address, AptNumber, CurrentCity, CurrentState, CurrentZip, CurrentHomePhone, CurrentAltPhoneNumber, CurrentEmail, SocialSecurityNumber, DriversLicense, IssuingState) values ('".$LastName."','".$FirstName."','".$MI."','".$Address."','".$AptNumber."','".$CurrentCity."','".$CurrentState."','".$CurrentZip."','".$CurrentHomePhone."','".$CurrentAltPhoneNumber."','".$CurrentEmail."','".$SocialSecurityNumber."','".$DriversLicense."','".$IssuingState."')";
$result = mysql_query($query);
mysql_select_db("database_name");
$query = "insert into table_02 (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."','". 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."')";
$result = mysql_query($query);
