By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,009 Members | 1,767 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,009 IT Pros & Developers. It's quick & easy.

PHP-MySQL Result Set Truncated in HTML CSS Page Height

P: 2
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
Share this Question
Share on Google+
1 Reply


drhowarddrfine
Expert 5K+
P: 7,435
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.