I created a search on a database. When the search results come back, they are duplicated one to several times and it makes the page look pretty bad. I'm using tables html code in my php page. For whatever reason after where the main table and page is supposed to end it starts duplicating but not from the beginning/top of the page.
Here is the code:
<?
$link=mysql_connect('host', 'database', 'password');
if (!$link) {
die('Could not connect: ' .mysql_error());
}
else
{
// Connected to the database
print("<table border=1 cellpadding=2 cellspacing=2 valign=top align=center width=900><td width=100% colspan=4 align=center><font face=arial size=4><b>Crossroads Health Care Management Web Portal</font></b></td><tr>\n");
}
@mysql_select_db( "table") or die( "Unable to select database");
$cliacct=$_POST['clientnum'];
$query = "SELECT dcs, cliref, guar, pat, addr1, addr2, city, st, zip, social, dob, phone, dbal, tbal, paid FROM crossroads10 WHERE cliref='$cliacct'";
$result=mysql_query($query);
if (!$result) {
$message = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $query;
die($message);
}
while ($row = mysql_fetch_assoc($result)) {
$dcs = $row['dcs'];
$cliref = $row['cliref'];
$guarantor = $row['guar'];
$patient = $row['pat'];
$address1 = $row['addr1'];
$address2 = $row['addr2'];
$city = $row['city'];
$state = $row['st'];
$zip = $row['zip'];
$social = $row['social'];
$dob = $row['dob'];
$phone = $row['phone'];
$ticketbal = $row['dbal'];
$totalbal = $row['tbal'];
$paid = $row['paid'];
print ("<td bgcolor=#003399 width=50% colspan=2><font face=arial size=2 color=#ffffff> Results for Client Account Number:<b> $cliacct</b></font></td><td bgcolor=#003399 width=50% colspan=2 align=center><font face=arial size=1 color=#ffffff>Provided By: Diversified Credit Systems (800) 256-3838</td><tr>");
print ("<td width=25% bgcolor=#666666><font face=arial size=2 color=#ffffff><b> DCS Account Number:</b></font></td><td width=25%><font face=arial size=2 color=#000000> $dcs</font></td>");
print ("<td width=25% bgcolor=#666666><font face=arial size=2 color=#ffffff><b>Client Account Number:</b></font></td><td width=25%><font face=arial size=2 color=#000000> $cliref</font></td><tr>");
print ("<td width=25% bgcolor=#666666><font face=arial size=2 color=#ffffff><b> Responsible Party:</b></font></td><td width=25%><font face=arial size=2 color=#000000> $guarantor</font></td>");
print ("<td width=25% bgcolor=#666666><font face=arial size=2 color=#ffffff><b> Patient: </b></font></td><td width=25%><font face=arial size=2 color=#000000> $patient</font></td><tr>");
print ("<td width=25% bgcolor=#666666><font face=arial size=2 color=#ffffff><b> Address: </b></font></td><td width=25%><font face=arial size=2 color=#000000>$address1</font></td>");
print ("<td width=25% bgcolor=#666666><font face=arial size=2 color=#ffffff><b> Address Line 2: </b></font></td><td width=25%><font face=arial size=2 color=#000000>$address2</font></td><tr>");
print ("<td width=100% colspan=4><table border=0 width=100% colspan=4><td width=16% bgcolor=#666666><font face=arial size=2 color=#ffffff><b>City</b></font></td><td width=16%><font face=arial size=2 color=#000000> $city </td><td width=16% bgcolor=#666666><font face=arial size=2 color=#ffffff><b>State</b></font></td><td width=16%><font face=arial size=2 color=#000000> $state</td><td width=16% bgcolor=#666666><font face=arial size=2 color=#ffffff><b>Zip Code</b></td><td width=16%><font face=arial size=2 color=#000000> $zip</font></td></table></td><tr>");
print ("<td width=25% bgcolor=#666666><font face=arial size=2 color=#ffffff><b> Social Security Number:</b></font></td><td width=25%><font face=arial size=2 color=#000000> $social</font></td>");
print ("<td width=25% bgcolor=#666666><font face=arial size=2 color=#ffffff><b> Date of Birth:</b></font></td><td width=25%><font face=arial size=2 color=#000000> $dob</font></td><tr>");
print ("<td width=50% colspan=2 bgcolor=#666666><font face=arial size=2 color=#ffffff><b>Phone:</b></font></td><td width=50% colspan=2><font face=arial size=2 color=#000000> $phone</font></td><tr>");
print ("<td width=100% colspan=4><table border=0 width=100% colspan=4><td width=16% bgcolor=#666666><font face=arial size=2 color=#ffffff><b> Encounter Balance: </b></font></td><td width=16%><font face=arial size=2 color=#000000>$ticketbal</font></td>");
print ("<td width=16% bgcolor=#666666><font face=arial size=2 color=#ffffff><b>Total Due:</b></font></td><td width=16%><font face=arial size=2 color=#000000> $totalbal</font></td>");
print ("<td width=16% bgcolor=#666666><font face=arial size=2 color=#ffffff><b>Total Paid:</b></font></td><td width=16%><font face=arial size=2 color=#000000> $paid</font></td></tr></table></td></tr>");
echo "<tr><td width=100% colspan=4><table border=0 width=100%><td align=left width=100% colspan=4 bgcolor=#003399><form action=\"confirm.php\">";
echo "<b><font face=arial size=2 color=#ffffff>Account Actions & Changes</font></b></td></tr>";
echo "<input type=hidden name=\"dcs\" value=\"$dcs\">";
echo "<input type=hidden name=\"cliref\" value=\"$cliref\">";
echo "<input type=hidden name=\"guarantor\" value=\"$guarantor\">";
echo "<td width=50% colspan=2><font face=arial size=2 color=#000000>Your Name <input type=\"text\" name=\"Name\"></font></td>";
echo "<td width=50% colspan=2><font face=arial size=2 color=#000000>Your Email <input type=\"text\" name=\"Email\"></font></td><tr>";
echo "<td width=25% align=center bgcolor=#CCCC00><input type=\"radio\" name=\"action\" value=\"Cancel Account\"> <font face=arial size=2>Cancel Account</font></td><td width=25% align=center bgcolor=#CCCC00> <input type=\"radio\" name=\"action\" value=\"Place Account On Hold\"> <font face=arial size=2>Place Account On Hold</font></td><td width=25% align=center bgcolor=#CCCC00> <input type=\"radio\" name=\"action\" value=\"Change Status\"> <font face=arial size=2>Change Status </font></td><td width=25% align=center bgcolor=#CCCC00><input type=\"radio\" name=\"action\" value=\"Remove From Credit\"><font face=arial size=2> Remove From Credit</font></td><tr>";
echo "<td width=25% align=center valign=top><font face=arial size=2 color=#000000>Reason For Cancellation<br><textarea name=\"cancelreason\" rows=3 cols=20></textarea></font></td>";
echo "<td width=25% align=center valign=top><font face=arial size=2 color=#000000><SELECT NAME=\"holddays\" SIZE=1><OPTION SELECTED value=\"Select Days\">Select Days<option value=\"30 Days\">30 Days<option value=\"60 Days\">60 Days<option value=\"90 Days\">90 Days</SELECT></font></td>";
echo "<td width=25% align=center valign=top><font face=arial size=2 color=#000000><SELECT NAME=\"status\" SIZE=1><OPTION SELECTED value=\"Select Status\">Select Status<OPTION value=\"Insurance (INS)\">Insurance (INS)<OPTION value=\"Attorney (ATA)\">Attorney (ATA)<OPTION value=\"Deceased No Assets (DNA)\">Deceased No Assets (DNA)<OPTION value=\"Deceased Checking Assets (DEC)\">Deceased Checking Assets (DEC)<OPTION value=\"Bankrupt (BNK)\">Bankrupt (BNK)</SELECT></font></td>";
echo "<td width=25% align=center valign=top><font face=arial size=2 color=#000000>Reason To Remove<br><textarea name=\"reasonremove\" rows=3 cols=20></textarea></font></td><tr>";
echo "<td width=50% colspan=2><font face=arial size=2 color=#000000>Comments or Questions<br><textarea name=\"Comments\" rows=5 cols=40></textarea></font></td><td width=50% colspan=2><a href=\"http://www.dcscollect.com/crossroads/webport.htm\"><font face=arial size=2>Click To Search For Another Account</a></font></tr><tr><td width=100% colspan=4>";
echo "<input type=submit name=Submit value=\"Submit\">";
echo "<input type=reset name=Reset value=\"Clear Form\">";
echo "</form></font></td></tr></table></tr></td></table>";
}
?>
Thanks
