table size in PHP

Anon

I am using php to produce a table to present data from a mysql database. one column is text and the rest are numbers from 1-9. my problem is that the text column is large and affects the height of the other columns. I have tried to adjust the height and width using standard commands, eg.

<td height ='15'> or width... with both single and double qoutes and it does not work. here is the code any ideas?

mysql_select_db("books");
$query = "select * from pgy1 where ".$searchtype." like '%".$searchterm."%'";
$result = mysql_query($query);

if ($result){
echo"<table border=1>";

print"<tr><td>Attending</td>
<td>Resident</td>
<td>History</td>
<td>Physical</td>
<td>Knowledge</td>
<td>Differential</td>
<td>Ancillary</td>
<td>Formulation</td>
<td>Documentation</td>
<td>Technical</td>
<td>Motivation</td>
<td>Dependablity</td>
<td>Criticisms</td>
<td>Professionalism</td>
<td>Attitude</td>
<td>Wound</td>
<td width='200' height = '5'>Comments</td>
</tr>";

$numOfRows = mysql_num_rows ($result);
for ($i = 0; $i < $numOfRows; $i++){
$attn = mysql_result ($result, $i, "attending");
$res = mysql_result ($result, $i, "resident");
$his = mysql_result ($result, $i, "history");
$phy = mysql_result ($result, $i, "physical");
$kno = mysql_result ($result, $i, "knowledge");
$dif = mysql_result ($result, $i, "differential");
$anc = mysql_result ($result, $i, "ancillary");
$for = mysql_result ($result, $i, "formulation");
$doc = mysql_result ($result, $i, "documentation");
$tec = mysql_result ($result, $i, "technical");
$mot = mysql_result ($result, $i, "motivation");
$dep = mysql_result ($result, $i, "dependablity");
$cri = mysql_result ($result, $i, "criticisms");
$pro = mysql_result ($result, $i, "professionalism");
$att = mysql_result ($result, $i, "attitude");
$wou = mysql_result ($result, $i, "wound");
$com = mysql_result ($result, $i, "comments");

print"
<tr><td>$attn</td>
<td>$res</td>
<td><center>$his</center></td>
<td><center>$phy</center></td>
<td><center>$kno</center></td>
<td><center>$dif</center></td>
<td><center>$anc</center></td>
<td><center>$for</center></td>
<td><center>$doc</center></td>
<td><center>$tec</center></td>
<td><center>$mot</center></td>
<td><center>$dep</center></td>
<td><center>$cri</center></td>
<td><center>$pro</center></td>
<td><center>$att</center></td>
<td><center>$wou</center></td>
<td width = '200' height = '5'>$com</td></tr>";
}

print"</table>";
}
else{
print mysql_errno().": ".mysql_error()." ";
}

mysql_close ();

thanks
Pat

Anon

you can't control column heights individually in tables. Don't really know what you're trying to do with layout, so can't really offer a suggestion.

Anon

all I really want to do is control the column width, and the code I am using does not seem to work.

Pat

angelblaze

so far i know the table is streched to accommodate the longest line so you need to devide your strings into smaller pieces so they continue on next line

Anon

If you're trying to control the column width, then you want to say width="whatever" instead of height; you'd probably want some valign="" attributes in your table cell tags as well. Percentages are probably more useful in this context than absolute pixel dimensions.

When you've got big text fields, then either the width or the height is going to have to stretch to contain it. If its height changes then the other cells on the same row will also have their height adjusted, to keep subsequent rows aligned, and if the width changes then the other cells in the column also change.

But are you saying that if the height of the cell changes, then it affects the height of other cells above and below it?!

Could you get away with eliding some text if it gets too long? Say dropping out a middle chunk and replacing it with '...'?

Incidentally, you might like to consider replacing those mysql_result() calls with a single call to mysql_fetch_array().