the recordset code is duplicated. lines 53 - 65
$colname_DetailRS1 = "-1";
if (isset($_GET['recordID'])) {
$colname_DetailRS1 = $_GET['recordID'];
}
mysql_select_db($database_conn1, $conn1);
$query_DetailRS1 = sprintf("SELECT * FROM boats WHERE RecNo = %s", GetSQLValueString($colname_DetailRS1, "int"));
$DetailRS1 = mysql_query($query_DetailRS1, $conn1) or die(mysql_error());
$row_DetailRS1 = mysql_fetch_assoc($DetailRS1);
$totalRows_DetailRS1 = mysql_num_rows($DetailRS1);
$query_DetailRS1 = "SELECT * FROM boats WHERE RecNo = RecNo";
$DetailRS1 = mysql_query($query_DetailRS1, $conn1) or die(mysql_error());
$row_DetailRS1 = mysql_fetch_assoc($DetailRS1);
$totalRows_DetailRS1 = mysql_num_rows($DetailRS1); ?>
should be:
$colname_DetailRS1 = "-1";
if (isset($_GET['RecNo'])) {
$colname_DetailRS1 = $_GET['RecNo'];
}
mysql_select_db($database_conn1, $conn1);
$query_DetailRS1 = sprintf("SELECT * FROM boats WHERE RecNo = %s", GetSQLValueString($colname_DetailRS1, "int"));
$DetailRS1 = mysql_query($query_DetailRS1, $conn1) or die(mysql_error());
$row_DetailRS1 = mysql_fetch_assoc($DetailRS1);
$totalRows_DetailRS1 = mysql_num_rows($DetailRS1); ?>