41
Hi
Multiple rows of dynamically created data is retrived from the database and displayed properly.
When I get 50 rows displayed scrolling is necessary.
The problem is when I scroll to see the items at the bottom of the list the rows get blurred (jumbled).
To be specific at the top and bottom rows of the list are displayed properly but in the middle the rows get blurred.
Can you you see something wrong with my code? How can I make this work?
Note: This is part of the code related to the problem
[php]
<?php
include("../config/db_connect_in.p hp");
?>
<html>
<body>
<?php
function ohip_fee_search _result_display ($org_code, $field, $searching, $find, $special,
$services, $schedule_year, $db_id)
{
$mysqli = db_connect();
db_select($mysq li, $db_id);
/*************** ** this section displays the services******* ********/
//search area display area layer and table
echo "<table width=\"99%\" border=\"0\">
<tr align=\"center\ " bgcolor=\"#FFFF FF\" height=\"\">
<td width=\"100%\" >
<div id=\"Layer2\" style=\"positio n:absolute; width:100%; height:320px; z-index:2; left: 4px; top: 510px;\">
<div id=\"pat-dash-scroll-box2\" style=\"overflo w: auto; float: left; width: 100%; height: 310px; margin: 0px; \">\n";
//table begins
echo "<table width=\"99%\" height=\"332\" left =\"40\" align = \"\" border=\"0\" font face =\"arial\">\n ";
/********** determine which and how to select data to display *********/
$data = "SELECT c.code_id, c.fee_code, c.description, m.general_fee,
FROM bill_ohip_fee_c ode c, $fee_master_tab le m
WHERE c.fee_code = m.code
AND c.section_code = '$services'
ORDER BY c.fee_code
";
$result = mysqli_query($m ysqli,$data) or die('Error, bottom query failed');
$num_service = mysqli_num_rows ($result);
for($i=0; $i < $num_service; $i++)
{
$row = mysqli_fetch_ar ray($result);
list($code_id, $fee1_code, $description, $s_fee) = $row;
if($i % 2) //alternate row colour
{
$bgcolor="#eeee e0";
}
else
{
$bgcolor="#ebea e0";
}
//diaplay search results in rows
echo"<tr height=\"10\">
<td width=\"4%\" bgcolor=\"#fff8 dc\" align=\"center\ ">
<input type=\"checkbox \" name=\"fee1_cho ice[$i]\" value=\"$code_i d\"></td>
<td width=\"7%\" bgcolor=\"#fff8 dc\" ><span class=\"style20 \"><strong>$fee 1_code</strong></span></td>
<td width=\"3%\" bgcolor=\"$bgco lor\" height=\"10\">
<input type=\"text\" name=\"fee1_uni t[$i]\" size=\"1\" maxlength=\"2\" value =\"$fee1_unit \"/>
</td>
<td width=\"79%\" bgcolor=\"$bgco lor\" class=\"style20 \"> $description </td>
<td width=\"6%\" align=\"left\"> $s_fee</td>\n";
echo"</tr>\n";
}//end of for loop
echo "</table>\n";
echo "</div>\n";
echo "</div>\n";
echo "</td>\n";
echo "</tr>\n";
echo "</table>\n";
}
?>
</body>
</html>
[/php]
