469,591 Members | 2,068 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,591 developers. It's quick & easy.

PHP-MySQL Result Set Truncated in HTML CSS Page Height

There is a truncation error of my Web Application using PHP 5.04, MySQL 5.022, and HTML(IE 6.0) whereby the MySQL Result Set is being truncated on the HTML page, even though the CSS Div Page Height is set to 'auto' which is supposed to grow the HTML page height to the size necessary to display the contents within the page. The query count is correct, but the MySQL Result Set is being truncated on the html page. This happens for MySQL Results on some HTML pages but not for others, despite the fact that they all use the same CSS Div.

This happens upon Viewing all:
-Client Accounts(19)
-Service Requests(49)
but not upon Viewing all:
-Consultants(7)
-Interviews(5)

Nor does it happen upon Viewing all:
-Service Requests per Client(eg Cherry Bank(21);Heritage Bank(9))
And the code structure is the same.
______________________

PHP Script(PHP & HTML)
______________________

<div id="Layer5" align="left">
<h1 class="style3 style4"><? echo "Operations<br></b>"; ?>
<span class="style5"></span></h1>
<?
$db = new mysqli($connection, $username, 'webpass', $db_name);
if(mysqli_connect_errno())
{
echo 'Error: Cound not connect to Database.';
exit;
}

$num_rows_client_account=0;

# 06 SQL - Find all 'Client Accounts' from 'client_account' table
$query="SELECT * FROM client_account";
$result=$db->query($query) or die("Select 'Client Accounts' SQL Query Failed on 'client_account' table: ".mysql_error());
$num_rows_client_account=$result->num_rows;

# If Client Account has more that 1 Service Request, Display them
if($num_rows_client_account > '0') {
echo '<h2><span class="style2">Client Accounts - '.$num_rows_client_account.'</span></h2>';
for($i=0;$i<$num_rows_client_account;$i++) {
$row=$result->fetch_assoc();

'service_request_id'] = $row['service_request_id'];
$client_account_id = substr($row['client_account_id'],0,10);
$company = $row['company'];
$status=$row['status'];
$current_client_account_id = $row['client_account_id'];

echo "<font color='brown'><ul type='square'><li><b><font color='blue'><a name='".$current_client_account_id."' client_account_id='".$num_rows_client_account."' href='view_service_request.php' target='_top' onclick='return set_consulting_sr_session_vars(this)';>".$row['client_account_id']."</a></b><font color='brown'> - ".$row['company']." - ".$row['status']."</a><font color='black'></li></ul>";
# echo '<ul><li>'.$i.'</li></ul>';
}

}
else
echo "<ul type='square'><li>There are no Client Accounts</li>";
$result->close();
$db->close();
?>
<p>&nbsp;</p>
</div>
_____________________

CSS
_____________________

#Layer5 {
position:relative;
width:623px;
height:auto;
z-index:5;
left: 293px;
top: 247px;
}
Oct 5 '06 #1
1 2979
drhowarddrfine
7,435 Expert 4TB
What you show has nothing to do with the problem. I have a lot of questions about the document itself since you use deprecated tags, such as, what doctype are you using? I would need the complete html and css code or, preferably, a link.
Oct 5 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by lawrence | last post: by
10 posts views Thread by Ruby Tuesdays | last post: by
7 posts views Thread by Timothy Madden | last post: by
13 posts views Thread by Don | last post: by
3 posts views Thread by Joseph S. | last post: by
9 posts views Thread by IchBin | last post: by
reply views Thread by Benjamin Grieshaber | last post: by
15 posts views Thread by mike | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.