STEP 3: Add Boat to the Registry
";
$i++;
}
} else {
echo "The boat with HIN: $HIN is NOT registered with this site. To register this boat, enter additional information, add a photo, and click submit.
"; $i=0; while ($i < $num) { $HIN=mysql_result($result,$i,"HIN"); $RecordNumber=mysql_result($result,$i,"RecordNumber"); $Manufacturer=mysql_result($result,$i,"Manufacturer"); $Toyota=mysql_result($result2,$i,"Toyota"); $Model=mysql_result($result2,$i,"Model"); $ModelYear=mysql_result($result2,$i,"ModelYear"); $HIN=mysql_result($result2,$i,"HIN"); $InteriorColor=mysql_result($result2,$i,"InteriorColor"); $ExteriorColor=mysql_result($result2,$i,"HullColor"); $OnePanel=mysql_result($result2,$i,"OnePanel"); $TwoPanel=mysql_result($result2,$i,"TwoPanel"); $ThreePanel=mysql_result($result2,$i,"ThreePanel"); $FourPanel=mysql_result($result2,$i,"FourPanel"); $Sequence=mysql_result($result2,$i,"Sequence"); $ManYear=mysql_result($result2,$i,"ManYear"); $Month=mysql_result($result2,$i,"Month"); $ValuePackage=mysql_result($result2,$i,"ValuePackage"); $BoatOptions=mysql_result($result2,$i,"BoatOptions"); $Options=mysql_result($result2,$i,"Options"); $ValuePackage=mysql_result($result2,$i,"ValuePackage"); $Tower=mysql_result($result,$i,"Tower"); $Trailer=mysql_result($result,$i,"Trailer"); $TowVehicle=mysql_result($result,$i,"TowVehicle"); $BiminiTop=mysql_result($result,$i,"BiminiTop"); $Cover=mysql_result($result,$i,"Cover"); $SwimPlatform=mysql_result($result,$i,"SwimPlatform"); $DriveTrain=mysql_result($result,$i,"DriveTrain"); $DriveTrainGearRatio=mysql_result($result,$i,"DriveTrainGearRatio"); $PropType=mysql_result($result,$i,"PropType"); $PropMfg=mysql_result($result,$i,"PropMfg"); $PropPitch=mysql_result($result,$i,"PropPitch"); $Stereo=mysql_result($result,$i,"Stereo"); $Ballast=mysql_result($result,$i,"Ballast"); $PhotoUrl=mysql_result($result,$i,"PhotoUrl"); $OwnerContact=mysql_result($result,$i,"OwnerContact"); $ForumUsername=mysql_result($result,$i,"ForumUsername"); $State=mysql_result($result,$i,"State"); $HomeLake=mysql_result($result,$i,"HomeLake"); $InstalledUpgrades=mysql_result($result,$i,"InstalledUpgrades"); $Comments=mysql_result($result,$i,"Comments"); $OriginalDealer=mysql_result($result,$i,"OriginalDealer"); echo "STEP 3: Verify/Edit Your Boat
Your boat is already registered as Record Number $RecordNumber. Enter or edit your info below.
"; mysql_connect($server,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); //run query on user registration table $query="SELECT * FROM m_reg WHERE `RecordNumber` LIKE '" . mysql_real_escape_string( $RecordNumber ) . "'"; $result=mysql_query($query); $num=mysql_numrows($result); //run query on TMS table $query="SELECT * FROM `HIN_reg` WHERE `HIN` LIKE '" . mysql_real_escape_string( $HIN ) . "'"; $result2=mysql_query($query); $num=mysql_numrows($result2); mysql_close(); $i=0; while ($i < $num) { $RecordNumber=mysql_result($result,$i,"RecordNumber"); $Manufacturer=mysql_result($result,$i,"Manufacturer"); $Toyota=mysql_result($result2,$i,"Toyota"); $Model=mysql_result($result2,$i,"Model"); $ModelYear=mysql_result($result2,$i,"ModelYear"); $HIN=mysql_result($result2,$i,"HIN"); $InteriorColor=mysql_result($result2,$i,"InteriorColor"); $ExteriorColor=mysql_result($result2,$i,"HullColor"); $OnePanel=mysql_result($result2,$i,"OnePanel"); $TwoPanel=mysql_result($result2,$i,"TwoPanel"); $ThreePanel=mysql_result($result2,$i,"ThreePanel"); $FourPanel=mysql_result($result2,$i,"FourPanel"); $Sequence=mysql_result($result2,$i,"Sequence"); $ManYear=mysql_result($result2,$i,"ManYear"); $Month=mysql_result($result2,$i,"Month"); $ValuePackage=mysql_result($result2,$i,"ValuePackage"); $BoatOptions=mysql_result($result2,$i,"BoatOptions"); $Options=mysql_result($result2,$i,"Options"); $ValuePackage=mysql_result($result2,$i,"ValuePackage"); $Tower=mysql_result($result,$i,"Tower"); $Trailer=mysql_result($result,$i,"Trailer"); $TowVehicle=mysql_result($result,$i,"TowVehicle"); $BiminiTop=mysql_result($result,$i,"BiminiTop"); $Cover=mysql_result($result,$i,"Cover"); $SwimPlatform=mysql_result($result,$i,"SwimPlatform"); $DriveTrain=mysql_result($result,$i,"DriveTrain"); $DriveTrainGearRatio=mysql_result($result,$i,"DriveTrainGearRatio"); $PropType=mysql_result($result,$i,"PropType"); $PropMfg=mysql_result($result,$i,"PropMfg"); $PropPitch=mysql_result($result,$i,"PropPitch"); $Stereo=mysql_result($result,$i,"Stereo"); $Ballast=mysql_result($result,$i,"Ballast"); $PhotoUrl=mysql_result($result,$i,"PhotoUrl"); $OwnerContact=mysql_result($result,$i,"OwnerContact"); $ForumUsername=mysql_result($result,$i,"ForumUsername"); $State=mysql_result($result,$i,"State"); $HomeLake=mysql_result($result,$i,"HomeLake"); $InstalledUpgrades=mysql_result($result,$i,"InstalledUpgrades"); $Comments=mysql_result($result,$i,"Comments"); $OriginalDealer=mysql_result($result,$i,"OriginalDealer"); echo "