Fixed sized rows in table

bobby_rahman

hiya

I have created a dynamic table in a html form. The page when refreshed queries the db and retrieves data.......filling in the table in the form. SIMPLE - thats working fine

But I have noticed in the html form that when it retrieves 0-1-2 rows then it seems to make all the rows massive and text really large. When there is more than 5 rows it seems to become more of a normal size (smaller) .

Is there anyway of setting fixed row size for 0-1-2....100 rows
in the html form or can anyone suggest a mistake in the creation
of my dynamic table. I apolagise if this kinda of query has been already posted - I couldnt find one similar:

Here the code:
<?
session_start();
require_once("db_api.php");
db_connect();

$db_result = mysql_query($_SESSION['querystring']) or die(mysql_error());
if( mysql_num_rows($db_result) == 0 )
{
echo("no records were found .");
}
else
{

echo("
<table width=\"70%\" height=\"180\" border=\"1\" cellspacing=\"1\" bgcolor=\"#FFFFFF\">
<tr>
<td colspan=\"8\" bgcolor=\"#9999FF\"> </td>
</tr>
<tr>
<td bgcolor=\"#99CCFF\">bugid</td>
<td bgcolor=\"#99CCFF\">status</td>
<td bgcolor=\"#99CCFF\">severity</td>
<td bgcolor=\"#99CCFF\">assigned_to</td>
<td bgcolor=\"#99CCFF\">summary</td>
<td bgcolor=\"#99CCFF\">date_opened</td>
<td bgcolor=\"#99CCFF\">estimation_completion</td>
<td bgcolor=\"#99CCFF\">related_file</td>
<td bgcolor=\"#99CCFF\">created_by</td>
</tr>
");

}
while( $row = mysql_fetch_array($db_result) )
{

    echo("
        		<tr $c>
            	<td><font face=\"Verdana, Arial, Helvetica, sans-serif\">" . $row['bugid'] . "</font></td> 
            	<td><font face=\"Verdana, Arial, Helvetica, sans-serif\">" . $row['status'] . "</font></td> 
            	<td><font face=\"Verdana, Arial, Helvetica, sans-serif\">" . $row['severity'] . "</font></td> 
            	<td><font face=\"Verdana, Arial, Helvetica, sans-serif\">" . $row['assigned_to'] . "</font></td> 
            	<td><font face=\"Verdana, Arial, Helvetica, sans-serif\">" . $row['summary'] . "</font></td> 
            	<td><font face=\"Verdana, Arial, Helvetica, sans-serif\">" . $row['date_opened'] . "</font></td> 
            	<td><font face=\"Verdana, Arial, Helvetica, sans-serif\">" . $row['estimated_completion'] . "</font></td> 
            	<td><font face=\"Verdana, Arial, Helvetica, sans-serif\">" . $row['related_file'] . "</font></td> 
            	<td><font face=\"Verdana, Arial, Helvetica, sans-serif\">" . $row['created_by'] . "</font></td> 
        		</tr> ");

if ( !isset($c) )
{
$c = "bgcolor=#9999FF"; }
else
{
unset($c);
}
}
echo("
<tr>
<td colspan=\"8\" bgcolor=\"#9999FF\"> </td>
</tr>
</table>
");

hermand

How come you didn't define the font size for the dynamic section?

press711

Try using CSS styles for font size . Also please remove the table height parameter or set it to 100%, I think that is your main problem.

Let me know if you still have troubles.

hermand

Aye, table height looks promising (Missed that!)

bobby_rahman

Hiya I have changed the table height to 100%, still no change in the browser table

Further detail

I call this file <the code below> by using

include("file.php") in the main page. I assume this dynamic rows size must be due to something in the code below.

Should i be using td width?

Bunkermaster

td width sounds good if you want all of them to have same width. If you don't set width it'll divide table width between cells taking content length as a reference.

Table height is just in case the table is not high enough once the data is generated (but it will divide its size between TRs)

I remind you that some browsers will ignore table height.

bobby_rahman

SORRY i changed td width instead of td height b4. Now it seems
rows seem to be better resized now 🙂 (though not one fixed size still) but it doesnt look so bad now so can live with it

Thanx for spotting that error

However now the strange thing is the dynamic table seems to be within a table when it has a few rows but NOT when there are more rows. I cant see another table within the code I stated originally.

bobby_rahman

Final analysis has lead me to get everything working by interestingly by taking out the <td width=\"100\" height=\"100\">.

All the rows seem to default to the same size what ever the no. of rows? I am curious to know why but Hey im not knocking it🙂

Cheers to all the PHP gods out there for the help....

Thanx

Bunkermaster

you set your table width as 75% of its available area. You have 9 fields (right?) so u have to set td width to 11% (100/9) if you want it to adapt 🙂