tomjenkins12
asked on
print to pdf using mysql and php
This information populates mysql data perfectly
but when i added
<?php "form2=$form2"?>
<p> </p>
<form action="<?php require("fpdf.php");
$pdf=new FPDF();
$pdf->AddPage();
$pdf->SetFont('Arial','B',
$pdf->Cell(40,10,echo "$form2");
$pdf->Output();
?>" method="post" name="PDF" target="_blank" id="PDF" dir="ltr">
<input name="SUBMIT PDF" type="submit" />
</form>
so that I can print the following information to print to pdf for each form and have it print all information on one form
It may be because i am not creating the array correctly any thoughts
I get
Parse error: parse error in E:\xampp\htdocs\intranet\d
but when i added
<?php "form2=$form2"?>
<p> </p>
<form action="<?php require("fpdf.php");
$pdf=new FPDF();
$pdf->AddPage();
$pdf->SetFont('Arial','B',
$pdf->Cell(40,10,echo "$form2");
$pdf->Output();
?>" method="post" name="PDF" target="_blank" id="PDF" dir="ltr">
<input name="SUBMIT PDF" type="submit" />
</form>
so that I can print the following information to print to pdf for each form and have it print all information on one form
It may be because i am not creating the array correctly any thoughts
I get
Parse error: parse error in E:\xampp\htdocs\intranet\d
<?php require_once('../../Connections/tablesfour.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form2")) {
$updateSQL = sprintf("UPDATE agency SET AGENCY=%s, `AGENT Address`=%s, `AGENT City`=%s, `AGENT St`=%s, `AGENT Zip`=%s, `AGENT FIRST`=%s, `AGENT MIDDLE`=%s, `AGENT LAST`=%s, `AGENT SUFF`=%s, `AGENT Phone`=%s, `AGENT Fax`=%s, `AGENTS EMAIL`=%s WHERE agencyid=%s",
GetSQLValueString($_POST['AGENCY'], "text"),
GetSQLValueString($_POST['AGENT_Address'], "text"),
GetSQLValueString($_POST['AGENT_City'], "text"),
GetSQLValueString($_POST['AGENT_St'], "text"),
GetSQLValueString($_POST['AGENT_Zip'], "text"),
GetSQLValueString($_POST['AGENT_FIRST'], "double"),
GetSQLValueString($_POST['AGENT_MIDDLE'], "text"),
GetSQLValueString($_POST['AGENT_LAST'], "text"),
GetSQLValueString($_POST['AGENT_SUFF'], "text"),
GetSQLValueString($_POST['AGENT_Phone'], "text"),
GetSQLValueString($_POST['AGENT_Fax'], "text"),
GetSQLValueString($_POST['AGENTS_EMAIL'], "text"),
GetSQLValueString($_POST['agencyid'], "int"));
mysql_select_db($database_tablesfour, $tablesfour);
$Result1 = mysql_query($updateSQL, $tablesfour) or die(mysql_error());
}
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form3")) {
$updateSQL = sprintf("UPDATE client SET `CLIENT NAME`=%s, `CLIENT Address`=%s, `CLIENT City`=%s, `CLIENT St`=%s, `CLIENT Zip`=%s, `CLIENT FIRST`=%s, `CLIENT MIDDLE`=%s, `CLIENT LAST`=%s, `CLIENT SUFF`=%s, `CLIENT PHONE`=%s, `CLIENT FAX`=%s, `CLIENTS EMAIL`=%s, Field14=%s, date_created=%s WHERE clientId=%s",
GetSQLValueString($_POST['CLIENT_NAME'], "text"),
GetSQLValueString($_POST['CLIENT_Address'], "text"),
GetSQLValueString($_POST['CLIENT_City'], "text"),
GetSQLValueString($_POST['CLIENT_St'], "text"),
GetSQLValueString($_POST['CLIENT_Zip'], "text"),
GetSQLValueString($_POST['CLIENT_FIRST'], "text"),
GetSQLValueString($_POST['CLIENT_MIDDLE'], "text"),
GetSQLValueString($_POST['CLIENT_LAST'], "text"),
GetSQLValueString($_POST['CLIENT_SUFF'], "text"),
GetSQLValueString($_POST['CLIENT_PHONE'], "text"),
GetSQLValueString($_POST['CLIENT_FAX'], "text"),
GetSQLValueString($_POST['CLIENTS_EMAIL'], "text"),
GetSQLValueString($_POST['Field14'], "text"),
GetSQLValueString($_POST['date_created'], "text"),
GetSQLValueString($_POST['clientId'], "int"));
mysql_select_db($database_tablesfour, $tablesfour);
$Result1 = mysql_query($updateSQL, $tablesfour) or die(mysql_error());
}
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
$updateSQL = sprintf("UPDATE obligee SET `OBLIGEE ADDRESS`=%s, `OBLIGEE CITY`=%s, `OBLIGEE STATE`=%s, `OBLIGEE ZIP`=%s, `OBLIGEE CONTACT`=%s, `OBLIGEE PHONE`=%s, `OBLIGEE FAX`=%s, `Obligee email`=%s WHERE Obligee=%s",
GetSQLValueString($_POST['OBLIGEE_ADDRESS'], "text"),
GetSQLValueString($_POST['OBLIGEE_CITY'], "text"),
GetSQLValueString($_POST['OBLIGEE_STATE'], "text"),
GetSQLValueString($_POST['OBLIGEE_ZIP'], "text"),
GetSQLValueString($_POST['OBLIGEE_CONTACT'], "double"),
GetSQLValueString($_POST['OBLIGEE_PHONE'], "text"),
GetSQLValueString($_POST['OBLIGEE_FAX'], "text"),
GetSQLValueString($_POST['Obligee_email'], "text"),
GetSQLValueString($_POST['Obligee'], "text"));
mysql_select_db($database_tablesfour, $tablesfour);
$Result1 = mysql_query($updateSQL, $tablesfour) or die(mysql_error());
}
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form4")) {
$updateSQL = sprintf("UPDATE accounting SET `CLIENT number`=%s, `1 2 etc`=%s, INS=%s, REDSTAR=%s, CLAIM=%s, COLL=%s, PURGE_DATE=%s, E=%s, `BOND NUMBER`=%s, Surety=%s, `Bond Type`=%s, `PAYING STATE`=%s, `BOND STATE`=%s, TERM=%s, `CANCELATION CLAUSE`=%s, `Bond Amt`=%s, `1st Issue Date`=%s, `Issue Date`=%s, `Exp Date`=%s, `RED STARED`=%s, `RED STAR DATE`=%s, `PURGE DATE`=%s, QUOTED=%s, `COMM FEE`=%s, `NET DUE`=%s, `Surety Gross`=%s, `Surety Net`=%s, `AGENT COMMISSION PERCENTAGE`=%s, `FL FEE`=%s, `NV FEE`=%s, `KY FEE`=%s, `RE INSTATMENT FEE`=%s, `RIDER FEE`=%s, `BROKER FEE`=%s, `CC FEE`=%s, `ON FEE`=%s, `PAYMENT RECD`=%s, INTL=%s, `DATE ENTERED`=%s, `UPDATED ENTERED`=%s, `UPDATED INTL`=%s, `COLLATERAL AND NOTES`=%s, Field44=%s WHERE clID=%s",
GetSQLValueString($_POST['CLIENT_number'], "int"),
GetSQLValueString($_POST['_2_etc'], "text"),
GetSQLValueString($_POST['INS'], "text"),
GetSQLValueString($_POST['REDSTAR'], "text"),
GetSQLValueString($_POST['CLAIM'], "text"),
GetSQLValueString($_POST['COLL'], "text"),
GetSQLValueString($_POST['PURGE_DATE'], "text"),
GetSQLValueString($_POST['E'], "text"),
GetSQLValueString($_POST['BOND_NUMBER'], "text"),
GetSQLValueString($_POST['Surety'], "text"),
GetSQLValueString($_POST['Bond_Type'], "text"),
GetSQLValueString($_POST['PAYING_STATE'], "text"),
GetSQLValueString($_POST['BOND_STATE'], "text"),
GetSQLValueString($_POST['TERM'], "text"),
GetSQLValueString($_POST['CANCELATION_CLAUSE'], "text"),
GetSQLValueString($_POST['Bond_Amt'], "text"),
GetSQLValueString($_POST['st_Issue_Date'], "text"),
GetSQLValueString($_POST['Issue_Date'], "text"),
GetSQLValueString($_POST['Exp_Date'], "text"),
GetSQLValueString($_POST['RED_STARED'], "text"),
GetSQLValueString($_POST['RED_STAR_DATE'], "text"),
GetSQLValueString($_POST['PURGE_DATE2'], "text"),
GetSQLValueString($_POST['QUOTED'], "text"),
GetSQLValueString($_POST['COMM_FEE'], "text"),
GetSQLValueString($_POST['NET_DUE'], "text"),
GetSQLValueString($_POST['Surety_Gross'], "text"),
GetSQLValueString($_POST['Surety_Net'], "text"),
GetSQLValueString($_POST['AGENT_COMMISSION_PERCENTAGE'], "text"),
GetSQLValueString($_POST['FL_FEE'], "text"),
GetSQLValueString($_POST['NV_FEE'], "text"),
GetSQLValueString($_POST['KY_FEE'], "text"),
GetSQLValueString($_POST['RE_INSTATMENT_FEE'], "text"),
GetSQLValueString($_POST['RIDER_FEE'], "text"),
GetSQLValueString($_POST['BROKER_FEE'], "text"),
GetSQLValueString($_POST['CC_FEE'], "text"),
GetSQLValueString($_POST['ON_FEE'], "text"),
GetSQLValueString($_POST['PAYMENT_RECD'], "text"),
GetSQLValueString($_POST['INTL'], "text"),
GetSQLValueString($_POST['DATE_ENTERED'], "text"),
GetSQLValueString($_POST['UPDATED_ENTERED'], "text"),
GetSQLValueString($_POST['UPDATED_INTL'], "text"),
GetSQLValueString($_POST['COLLATERAL_AND_NOTES'], "text"),
GetSQLValueString($_POST['Field44'], "text"),
GetSQLValueString($_POST['clID'], "int"));
mysql_select_db($database_tablesfour, $tablesfour);
$Result1 = mysql_query($updateSQL, $tablesfour) or die(mysql_error());
}
$colname_DetailRS1 = "-1";
if (isset($_GET['recordID'])) {
$colname_DetailRS1 = $_GET['recordID'];
}
$colname1_DetailRS1 = "-1";
if (isset($_GET['recordID'])) {
$colname1_DetailRS1 = $_GET['recordID'];
}
$colname3_DetailRS1 = "-1";
if (isset($_GET['recordID'])) {
$colname3_DetailRS1 = $_GET['recordID'];
}
$colname4_DetailRS1 = "-1";
if (isset($_GET['recordID'])) {
$colname4_DetailRS1 = $_GET['recordID'];
}
mysql_select_db($database_tablesfour, $tablesfour);
$query_DetailRS1 = sprintf("SELECT * FROM agency, client, obligee,accounting WHERE agency.AgencyID = %s AND client.AgencyID =%s and obligee.obligeeID=%s and accounting.clid=%s ", GetSQLValueString($colname_DetailRS1, "int"),GetSQLValueString($colname1_DetailRS1, "int"),GetSQLValueString($colname3_DetailRS1, "int"),GetSQLValueString($colname4_DetailRS1, "int"));
$DetailRS1 = mysql_query($query_DetailRS1, $tablesfour) or die(mysql_error());
$row_DetailRS1 = mysql_fetch_assoc($DetailRS1);
$totalRows_DetailRS1 = mysql_num_rows($DetailRS1);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Details</title>
<script src="../../SpryAssets/SpryCollapsiblePanel.js" type="text/javascript"></script>
<link href="../../SpryAssets/SpryCollapsiblePanel.css" rel="stylesheet" type="text/css" />
</head>
<body>
<p> </p>
<?php "form2=$form2"?>
<p> </p>
<form action="<?php require("fpdf.php");
$pdf=new FPDF();
$pdf->AddPage();
$pdf->SetFont('Arial','B',16);
$pdf->Cell(40,10,echo "$form2");
$pdf->Output();
?>" method="post" name="PDF" target="_blank" id="PDF" dir="ltr">
<input name="SUBMIT PDF" type="submit" />
</form>
<table border="1" align="left">
<tr>
<td width="249" align="left" valign="top" bgcolor="#FF0000">agencyid
<div id="CollapsiblePanel2" class="CollapsiblePanel">
<div class="CollapsiblePanelTab" tabindex="0"> Edit Agency</div>
<div class="CollapsiblePanelContent">
<form action="<?php echo $editFormAction; ?>" method="post" name="form2" id="form2">
<table align="center">
<tr valign="baseline">
<td nowrap="nowrap" align="right">AGENCY:</td>
<td><input type="text" name="AGENCY" value="<?php echo htmlentities($row_DetailRS1['AGENCY'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">AGENT Address:</td>
<td><input type="text" name="AGENT_Address" value="<?php echo htmlentities($row_DetailRS1['AGENT Address'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">AGENT City:</td>
<td><input type="text" name="AGENT_City" value="<?php echo htmlentities($row_DetailRS1['AGENT City'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">AGENT St:</td>
<td><input type="text" name="AGENT_St" value="<?php echo htmlentities($row_DetailRS1['AGENT St'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">AGENT Zip:</td>
<td><input type="text" name="AGENT_Zip" value="<?php echo htmlentities($row_DetailRS1['AGENT Zip'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">AGENT FIRST:</td>
<td><input type="text" name="AGENT_FIRST" value="<?php echo htmlentities($row_DetailRS1['AGENT FIRST'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">AGENT MIDDLE:</td>
<td><input type="text" name="AGENT_MIDDLE" value="<?php echo htmlentities($row_DetailRS1['AGENT MIDDLE'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">AGENT LAST:</td>
<td><input type="text" name="AGENT_LAST" value="<?php echo htmlentities($row_DetailRS1['AGENT LAST'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">AGENT SUFF:</td>
<td><input type="text" name="AGENT_SUFF" value="<?php echo htmlentities($row_DetailRS1['AGENT SUFF'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">AGENT Phone:</td>
<td><input type="text" name="AGENT_Phone" value="<?php echo htmlentities($row_DetailRS1['AGENT Phone'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">AGENT Fax:</td>
<td><input type="text" name="AGENT_Fax" value="<?php echo htmlentities($row_DetailRS1['AGENT Fax'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">AGENTS EMAIL:</td>
<td><input type="text" name="AGENTS_EMAIL" value="<?php echo htmlentities($row_DetailRS1['AGENTS EMAIL'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"> </td>
<td><input type="submit" value="Update record" /></td>
</tr>
</table>
<input type="hidden" name="MM_update" value="form2" />
<input type="hidden" name="agencyid" value="<?php echo $row_DetailRS1['agencyid']; ?>" />
</form></div>
</div></td>
<td width="286" align="left" valign="top"><?php echo $row_DetailRS1['agencyid']; ?></td>
</tr>
<tr>
<td align="left" valign="top" bgcolor="#FF0000">AGENCY </td>
<td align="left" valign="top"><?php echo $row_DetailRS1['AGENCY']; ?></td>
</tr>
<tr>
<td align="left" valign="top" bgcolor="#FF0000">AGENT Address</td>
<td align="left" valign="top"><?php echo $row_DetailRS1['AGENT Address']; ?></td>
</tr>
<tr>
<td align="left" valign="top" bgcolor="#FF0000">AGENT City</td>
<td align="left" valign="top"><?php echo $row_DetailRS1['AGENT City']; ?></td>
</tr>
<tr>
<td align="left" valign="top" bgcolor="#FF0000">AGENT St</td>
<td align="left" valign="top"><?php echo $row_DetailRS1['AGENT St']; ?></td>
</tr>
<tr>
<td align="left" valign="top" bgcolor="#FF0000">AGENT Zip</td>
<td align="left" valign="top"><?php echo $row_DetailRS1['AGENT Zip']; ?></td>
</tr>
<tr>
<td align="left" valign="top" bgcolor="#FF0000">AGENT FIRST</td>
<td align="left" valign="top"><?php echo $row_DetailRS1['AGENT FIRST']; ?></td>
</tr>
<tr>
<td align="left" valign="top" bgcolor="#FF0000">AGENT MIDDLE</td>
<td align="left" valign="top"><?php echo $row_DetailRS1['AGENT MIDDLE']; ?></td>
</tr>
<tr>
<td align="left" valign="top" bgcolor="#FF0000">AGENT LAST</td>
<td align="left" valign="top"><?php echo $row_DetailRS1['AGENT LAST']; ?></td>
</tr>
<tr>
<td align="left" valign="top" bgcolor="#FF0000">AGENT SUFF</td>
<td align="left" valign="top"><?php echo $row_DetailRS1['AGENT SUFF']; ?></td>
</tr>
<tr>
<td align="left" valign="top" bgcolor="#FF0000">AGENT Phone</td>
<td align="left" valign="top"><?php echo $row_DetailRS1['AGENT Phone']; ?></td>
</tr>
<tr>
<td align="left" valign="top" bgcolor="#FF0000">AGENT Fax</td>
<td align="left" valign="top"><?php echo $row_DetailRS1['AGENT Fax']; ?></td>
</tr>
<tr>
<td align="left" valign="top" bgcolor="#FF0000">AGENTS EMAIL</td>
<td align="left" valign="top"><?php echo $row_DetailRS1['AGENTS EMAIL']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#999999">clid </td>
<td valign="top"><?php echo $row_DetailRS1['clid']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#999999">clientId
<div id="CollapsiblePanel3" class="CollapsiblePanel">
<div class="CollapsiblePanelTab" tabindex="0">Edit Client</div>
<div class="CollapsiblePanelContent">
<form action="<?php echo $editFormAction; ?>" method="post" name="form3" id="form3">
<table align="center">
<tr valign="baseline">
<td nowrap="nowrap" align="right">CLIENT NAME:</td>
<td><input type="text" name="CLIENT_NAME" value="<?php echo htmlentities($row_DetailRS1['CLIENT NAME'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">CLIENT Address:</td>
<td><input type="text" name="CLIENT_Address" value="<?php echo htmlentities($row_DetailRS1['CLIENT Address'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">CLIENT City:</td>
<td><input type="text" name="CLIENT_City" value="<?php echo htmlentities($row_DetailRS1['CLIENT City'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">CLIENT St:</td>
<td><input type="text" name="CLIENT_St" value="<?php echo htmlentities($row_DetailRS1['CLIENT St'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">CLIENT Zip:</td>
<td><input type="text" name="CLIENT_Zip" value="<?php echo htmlentities($row_DetailRS1['CLIENT Zip'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">CLIENT FIRST:</td>
<td><input type="text" name="CLIENT_FIRST" value="<?php echo htmlentities($row_DetailRS1['CLIENT FIRST'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">CLIENT MIDDLE:</td>
<td><input type="text" name="CLIENT_MIDDLE" value="<?php echo htmlentities($row_DetailRS1['CLIENT MIDDLE'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">CLIENT LAST:</td>
<td><input type="text" name="CLIENT_LAST" value="<?php echo htmlentities($row_DetailRS1['CLIENT LAST'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">CLIENT SUFF:</td>
<td><input type="text" name="CLIENT_SUFF" value="<?php echo htmlentities($row_DetailRS1['CLIENT SUFF'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">CLIENT PHONE:</td>
<td><input type="text" name="CLIENT_PHONE" value="<?php echo htmlentities($row_DetailRS1['CLIENT PHONE'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">CLIENT FAX:</td>
<td><input type="text" name="CLIENT_FAX" value="<?php echo htmlentities($row_DetailRS1['CLIENT FAX'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">CLIENTS EMAIL:</td>
<td><input type="text" name="CLIENTS_EMAIL" value="<?php echo htmlentities($row_DetailRS1['CLIENTS EMAIL'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Field14:</td>
<td><input type="text" name="Field14" value="<?php echo htmlentities($row_DetailRS1['Field14'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Date_created:</td>
<td><input type="text" name="date_created" value="<?php echo htmlentities($row_DetailRS1['date_created'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"> </td>
<td><input type="submit" value="Update record" /></td>
</tr>
</table>
<input type="hidden" name="MM_update" value="form3" />
<input type="hidden" name="clientId" value="<?php echo $row_DetailRS1['clientId']; ?>" />
</form></div>
</div></td>
<td valign="top"><?php echo $row_DetailRS1['clientId']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#999999">CLIENT NAME</td>
<td valign="top"><?php echo $row_DetailRS1['CLIENT NAME']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#999999">CLIENT Address</td>
<td valign="top"><?php echo $row_DetailRS1['CLIENT Address']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#999999">CLIENT City</td>
<td valign="top"><?php echo $row_DetailRS1['CLIENT City']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#999999">CLIENT St</td>
<td valign="top"><?php echo $row_DetailRS1['CLIENT St']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#999999">CLIENT Zip</td>
<td valign="top"><?php echo $row_DetailRS1['CLIENT Zip']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#999999">CLIENT FIRST</td>
<td valign="top"><?php echo $row_DetailRS1['CLIENT FIRST']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#999999">CLIENT MIDDLE</td>
<td valign="top"><?php echo $row_DetailRS1['CLIENT MIDDLE']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#999999">CLIENT LAST</td>
<td valign="top"><?php echo $row_DetailRS1['CLIENT LAST']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#999999">CLIENT SUFF</td>
<td valign="top"><?php echo $row_DetailRS1['CLIENT SUFF']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#999999">CLIENT PHONE</td>
<td valign="top"><?php echo $row_DetailRS1['CLIENT PHONE']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#999999">CLIENT FAX</td>
<td valign="top"><?php echo $row_DetailRS1['CLIENT FAX']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#999999">CLIENTS EMAIL</td>
<td valign="top"><?php echo $row_DetailRS1['CLIENTS EMAIL']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#999999">Field14</td>
<td valign="top"><?php echo $row_DetailRS1['Field14']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">agencyid</td>
<td valign="top"><?php echo $row_DetailRS1['agencyid']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">date_created</td>
<td valign="top"><?php echo $row_DetailRS1['date_created']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">clid</td>
<td valign="top"><?php echo $row_DetailRS1['clid']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">Obligee
<div id="CollapsiblePanel1" class="CollapsiblePanel">
<div class="CollapsiblePanelTab" tabindex="0">Edit Obligee</div>
<div class="CollapsiblePanelContent">Content <form action="<?php echo $editFormAction; ?>" method="post" name="form1" id="form1">
<table align="center">
<tr valign="baseline">
<td nowrap="nowrap" align="right">Obligee:</td>
<td><?php echo $row_DetailRS1['Obligee']; ?></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">OBLIGEE ADDRESS:</td>
<td><input type="text" name="OBLIGEE_ADDRESS" value="<?php echo htmlentities($row_DetailRS1['OBLIGEE ADDRESS'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">OBLIGEE CITY:</td>
<td><input type="text" name="OBLIGEE_CITY" value="<?php echo htmlentities($row_DetailRS1['OBLIGEE CITY'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">OBLIGEE STATE:</td>
<td><input type="text" name="OBLIGEE_STATE" value="<?php echo htmlentities($row_DetailRS1['OBLIGEE STATE'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">OBLIGEE ZIP:</td>
<td><input type="text" name="OBLIGEE_ZIP" value="<?php echo htmlentities($row_DetailRS1['OBLIGEE ZIP'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">OBLIGEE CONTACT:</td>
<td><input type="text" name="OBLIGEE_CONTACT" value="<?php echo htmlentities($row_DetailRS1['OBLIGEE CONTACT'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">OBLIGEE PHONE:</td>
<td><input type="text" name="OBLIGEE_PHONE" value="<?php echo htmlentities($row_DetailRS1['OBLIGEE PHONE'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">OBLIGEE FAX:</td>
<td><input type="text" name="OBLIGEE_FAX" value="<?php echo htmlentities($row_DetailRS1['OBLIGEE FAX'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Obligee email:</td>
<td><input type="text" name="Obligee_email" value="<?php echo htmlentities($row_DetailRS1['Obligee email'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"> </td>
<td><input type="submit" value="Update record" /></td>
</tr>
</table>
<input type="hidden" name="MM_update" value="form1" />
<input type="hidden" name="Obligee" value="<?php echo $row_DetailRS1['Obligee']; ?>" />
</form></div>
</div></td>
<td valign="top"><?php echo $row_DetailRS1['Obligee']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">OBLIGEE ADDRESS</td>
<td valign="top"><?php echo $row_DetailRS1['OBLIGEE ADDRESS']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">OBLIGEE CITY</td>
<td valign="top"><?php echo $row_DetailRS1['OBLIGEE CITY']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">OBLIGEE STATE</td>
<td valign="top"><?php echo $row_DetailRS1['OBLIGEE STATE']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">OBLIGEE ZIP</td>
<td valign="top"><?php echo $row_DetailRS1['OBLIGEE ZIP']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">OBLIGEE CONTACT</td>
<td valign="top"><?php echo $row_DetailRS1['OBLIGEE CONTACT']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">OBLIGEE PHONE</td>
<td valign="top"><?php echo $row_DetailRS1['OBLIGEE PHONE']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">OBLIGEE FAX</td>
<td valign="top"><?php echo $row_DetailRS1['OBLIGEE FAX']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">obligeeID</td>
<td valign="top"><?php echo $row_DetailRS1['obligeeID']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">Obligee email</td>
<td valign="top"><?php echo $row_DetailRS1['Obligee email']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">clientID</td>
<td valign="top"><?php echo $row_DetailRS1['clientID']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">clID</td>
<td valign="top"><?php echo $row_DetailRS1['clID']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">CLIENT number
<div id="CollapsiblePanel4" class="CollapsiblePanel">
<div class="CollapsiblePanelTab" tabindex="0"> Edit Accounting </div>
<div class="CollapsiblePanelContent">Content
<form action="<?php echo $editFormAction; ?>" method="post" name="form4" id="form4">
<table align="center">
<tr valign="baseline">
<td nowrap="nowrap" align="right">CLIENT number:</td>
<td><input type="text" name="CLIENT_number" value="<?php echo htmlentities($row_DetailRS1['CLIENT number'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">1 2 etc:</td>
<td><input type="text" name="_2_etc" value="<?php echo htmlentities($row_DetailRS1['1 2 etc'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">INS:</td>
<td><input type="text" name="INS" value="<?php echo htmlentities($row_DetailRS1['INS'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">REDSTAR:</td>
<td><input type="text" name="REDSTAR" value="<?php echo htmlentities($row_DetailRS1['REDSTAR'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">CLAIM:</td>
<td><input type="text" name="CLAIM" value="<?php echo htmlentities($row_DetailRS1['CLAIM'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">COLL:</td>
<td><input type="text" name="COLL" value="<?php echo htmlentities($row_DetailRS1['COLL'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">PURGE_DATE:</td>
<td><input type="text" name="PURGE_DATE" value="<?php echo htmlentities($row_DetailRS1['PURGE_DATE'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">E:</td>
<td><input type="text" name="E" value="<?php echo htmlentities($row_DetailRS1['E'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">BOND NUMBER:</td>
<td><input type="text" name="BOND_NUMBER" value="<?php echo htmlentities($row_DetailRS1['BOND NUMBER'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Surety:</td>
<td><input type="text" name="Surety" value="<?php echo htmlentities($row_DetailRS1['Surety'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Bond Type:</td>
<td><input type="text" name="Bond_Type" value="<?php echo htmlentities($row_DetailRS1['Bond Type'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">PAYING STATE:</td>
<td><input type="text" name="PAYING_STATE" value="<?php echo htmlentities($row_DetailRS1['PAYING STATE'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">BOND STATE:</td>
<td><input type="text" name="BOND_STATE" value="<?php echo htmlentities($row_DetailRS1['BOND STATE'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">TERM:</td>
<td><input type="text" name="TERM" value="<?php echo htmlentities($row_DetailRS1['TERM'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">CANCELATION CLAUSE:</td>
<td><input type="text" name="CANCELATION_CLAUSE" value="<?php echo htmlentities($row_DetailRS1['CANCELATION CLAUSE'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Bond Amt:</td>
<td><input type="text" name="Bond_Amt" value="<?php echo htmlentities($row_DetailRS1['Bond Amt'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">1st Issue Date:</td>
<td><input type="text" name="st_Issue_Date" value="<?php echo htmlentities($row_DetailRS1['1st Issue Date'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Issue Date:</td>
<td><input type="text" name="Issue_Date" value="<?php echo htmlentities($row_DetailRS1['Issue Date'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Exp Date:</td>
<td><input type="text" name="Exp_Date" value="<?php echo htmlentities($row_DetailRS1['Exp Date'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">RED STARED:</td>
<td><input type="text" name="RED_STARED" value="<?php echo htmlentities($row_DetailRS1['RED STARED'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">RED STAR DATE:</td>
<td><input type="text" name="RED_STAR_DATE" value="<?php echo htmlentities($row_DetailRS1['RED STAR DATE'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">PURGE DATE:</td>
<td><input type="text" name="PURGE_DATE2" value="<?php echo htmlentities($row_DetailRS1['PURGE DATE'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">QUOTED:</td>
<td><input type="text" name="QUOTED" value="<?php echo htmlentities($row_DetailRS1['QUOTED'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">COMM FEE:</td>
<td><input type="text" name="COMM_FEE" value="<?php echo htmlentities($row_DetailRS1['COMM FEE'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">NET DUE:</td>
<td><input type="text" name="NET_DUE" value="<?php echo htmlentities($row_DetailRS1['NET DUE'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Surety Gross:</td>
<td><input type="text" name="Surety_Gross" value="<?php echo htmlentities($row_DetailRS1['Surety Gross'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Surety Net:</td>
<td><input type="text" name="Surety_Net" value="<?php echo htmlentities($row_DetailRS1['Surety Net'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">AGENT COMMISSION PERCENTAGE:</td>
<td><input type="text" name="AGENT_COMMISSION_PERCENTAGE" value="<?php echo htmlentities($row_DetailRS1['AGENT COMMISSION PERCENTAGE'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">FL FEE:</td>
<td><input type="text" name="FL_FEE" value="<?php echo htmlentities($row_DetailRS1['FL FEE'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">NV FEE:</td>
<td><input type="text" name="NV_FEE" value="<?php echo htmlentities($row_DetailRS1['NV FEE'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">KY FEE:</td>
<td><input type="text" name="KY_FEE" value="<?php echo htmlentities($row_DetailRS1['KY FEE'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">RE INSTATMENT FEE:</td>
<td><input type="text" name="RE_INSTATMENT_FEE" value="<?php echo htmlentities($row_DetailRS1['RE INSTATMENT FEE'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">RIDER FEE:</td>
<td><input type="text" name="RIDER_FEE" value="<?php echo htmlentities($row_DetailRS1['RIDER FEE'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">BROKER FEE:</td>
<td><input type="text" name="BROKER_FEE" value="<?php echo htmlentities($row_DetailRS1['BROKER FEE'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">CC FEE:</td>
<td><input type="text" name="CC_FEE" value="<?php echo htmlentities($row_DetailRS1['CC FEE'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">ON FEE:</td>
<td><input type="text" name="ON_FEE" value="<?php echo htmlentities($row_DetailRS1['ON FEE'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">PAYMENT RECD:</td>
<td><input type="text" name="PAYMENT_RECD" value="<?php echo htmlentities($row_DetailRS1['PAYMENT RECD'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">INTL:</td>
<td><input type="text" name="INTL" value="<?php echo htmlentities($row_DetailRS1['INTL'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">DATE ENTERED:</td>
<td><input type="text" name="DATE_ENTERED" value="<?php echo htmlentities($row_DetailRS1['DATE ENTERED'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">UPDATED ENTERED:</td>
<td><input type="text" name="UPDATED_ENTERED" value="<?php echo htmlentities($row_DetailRS1['UPDATED ENTERED'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">UPDATED INTL:</td>
<td><input type="text" name="UPDATED_INTL" value="<?php echo htmlentities($row_DetailRS1['UPDATED INTL'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">COLLATERAL AND NOTES:</td>
<td><input type="text" name="COLLATERAL_AND_NOTES" value="<?php echo htmlentities($row_DetailRS1['COLLATERAL AND NOTES'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Field44:</td>
<td><input type="text" name="Field44" value="<?php echo htmlentities($row_DetailRS1['Field44'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"> </td>
<td><input type="submit" value="Update record" /></td>
</tr>
</table>
<input type="hidden" name="MM_update" value="form4" />
<input type="hidden" name="clID" value="<?php echo $row_DetailRS1['clID']; ?>" />
</form></div>
</div></td>
<td valign="top"><?php echo $row_DetailRS1['CLIENT number']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">1 2 etc</td>
<td valign="top"><?php echo $row_DetailRS1['1 2 etc']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">INS</td>
<td valign="top"><?php echo $row_DetailRS1['INS']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">REDSTAR</td>
<td valign="top"><?php echo $row_DetailRS1['REDSTAR']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">CLAIM</td>
<td valign="top"><?php echo $row_DetailRS1['CLAIM']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">COLL</td>
<td valign="top"><?php echo $row_DetailRS1['COLL']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">PURGE</td>
<td valign="top"><?php echo $row_DetailRS1['PURGE']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">E</td>
<td valign="top"><?php echo $row_DetailRS1['E']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">BOND NUMBER</td>
<td valign="top"><?php echo $row_DetailRS1['BOND NUMBER']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">Surety</td>
<td valign="top"><?php echo $row_DetailRS1['Surety']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">Bond Type</td>
<td valign="top"><?php echo $row_DetailRS1['Bond Type']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">PAYING STATE</td>
<td valign="top"><?php echo $row_DetailRS1['PAYING STATE']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">BOND STATE</td>
<td valign="top"><?php echo $row_DetailRS1['BOND STATE']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">TERM</td>
<td valign="top"><?php echo $row_DetailRS1['TERM']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">CANCELATION CLAUSE</td>
<td valign="top"><?php echo $row_DetailRS1['CANCELATION CLAUSE']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">Bond Amt</td>
<td valign="top"><?php echo $row_DetailRS1['Bond Amt']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">1st Issue Date</td>
<td valign="top"><?php echo $row_DetailRS1['1st Issue Date']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">Issue Date</td>
<td valign="top"><?php echo $row_DetailRS1['Issue Date']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">Exp Date</td>
<td valign="top"><?php echo $row_DetailRS1['Exp Date']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">RED STARED</td>
<td valign="top"><?php echo $row_DetailRS1['RED STARED']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">RED STAR DATE</td>
<td valign="top"><?php echo $row_DetailRS1['RED STAR DATE']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">PURGE DATE</td>
<td valign="top"><?php echo $row_DetailRS1['PURGE DATE']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">QUOTED</td>
<td valign="top"><?php echo $row_DetailRS1['QUOTED']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">COMM FEE</td>
<td valign="top"><?php echo $row_DetailRS1['COMM FEE']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">NET DUE</td>
<td valign="top"><?php echo $row_DetailRS1['NET DUE']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">Surety Gross</td>
<td valign="top"><?php echo $row_DetailRS1['Surety Gross']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">Surety Net</td>
<td valign="top"><?php echo $row_DetailRS1['Surety Net']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC"><p>AGENT COMMISSION </p>
<p>PERCENTAGE</p></td>
<td valign="top"><?php echo $row_DetailRS1['AGENT COMMISSION PERCENTAGE']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">FL FEE</td>
<td valign="top"><?php echo $row_DetailRS1['FL FEE']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">NV FEE</td>
<td valign="top"><?php echo $row_DetailRS1['NV FEE']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">KY FEE</td>
<td valign="top"><?php echo $row_DetailRS1['KY FEE']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">RE INSTATMENT FEE</td>
<td valign="top"><?php echo $row_DetailRS1['RE INSTATMENT FEE']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">RIDER FEE</td>
<td valign="top"><?php echo $row_DetailRS1['RIDER FEE']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">BROKER FEE</td>
<td valign="top"><?php echo $row_DetailRS1['BROKER FEE']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">CC FEE</td>
<td valign="top"><?php echo $row_DetailRS1['CC FEE']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">ON FEE</td>
<td valign="top"><?php echo $row_DetailRS1['ON FEE']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">PAYMENT RECD</td>
<td valign="top"><?php echo $row_DetailRS1['PAYMENT RECD']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">INTL</td>
<td valign="top"><?php echo $row_DetailRS1['INTL']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">DATE ENTERED</td>
<td valign="top"><?php echo $row_DetailRS1['DATE ENTERED']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">UPDATED ENTERED</td>
<td valign="top"><?php echo $row_DetailRS1['UPDATED ENTERED']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">UPDATED INTL</td>
<td valign="top"><?php echo $row_DetailRS1['UPDATED INTL']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">COLLATERAL AND NOTES</td>
<td valign="top"><?php echo $row_DetailRS1['COLLATERAL AND NOTES']; ?></td>
</tr>
<tr>
<td valign="top" bgcolor="#0066CC">Field44 </td>
<td valign="top"><?php echo $row_DetailRS1['Field44']; ?></td>
</tr>
</table>
<script type="text/javascript">
<!--
var CollapsiblePanel2 = new Spry.Widget.CollapsiblePanel("CollapsiblePanel2", {contentIsOpen:false});
var CollapsiblePanel3 = new Spry.Widget.CollapsiblePanel("CollapsiblePanel3", {contentIsOpen:false});
var CollapsiblePanel1 = new Spry.Widget.CollapsiblePanel("CollapsiblePanel1", {contentIsOpen:false});
var CollapsiblePanel4 = new Spry.Widget.CollapsiblePanel("CollapsiblePanel4", {contentIsOpen:false});
//-->
</script>
</body>
</html>
<?php
mysql_free_result($DetailRS1);
?>
ASKER
tablesfour is th database name form mysql
ASKER
is there a better way to take existing information and post it to a pdf?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That looks a bit messy.
Try changing the line 219 from
$pdf->Cell(40,10,echo "$form2");
to
$pdf->Cell(40,10,"form2");
and see what happens?
If this didn't work (doubtful :)), it'd be helpful to have a copy of the tablesfour.php source code.