Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Oct 2006
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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;
    }

  • #2
    Regular Coder
    Join Date
    Sep 2006
    Location
    Vermont, USA
    Posts
    154
    Thanks
    0
    Thanked 6 Times in 6 Posts
    My only suggestion is to make sure the parent element(s) are also set to height:auto/100%
    Active PHP/MySQL application developer available for immediate work.
    syosoft.com mavieo.com - Remote Web Site Administration Suite - Reseller Ready


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •