PHP generated Table question

Anon

boy, i'm just full of questions today 🙂

anyway, Okay, so I have PHP generate a table for me using the following code
print"<center><hr width=50% height=2><br><h3>Record Number: $row[0]</h3></center>";
print "<table border = 1 valign=center width=100%>
print"<tr bgcolor=\"#CCCCCC\"> <td>Date of Entry</td><td><center>Person who Entered Info<center></td><td><center>Region</center></td>";
print"<td><center>State</center></td><td><center>County</center></td><td><center>Topic</center></font></td>";
print"<td><center>Product</center></td><td><center>Producer/Credit</center><td><center>Time Scale</center><td><center>Description</center><td><center>Link</center>
</td></tr> ";
print "<td> $row[1]</td> ";
print "<td> $row[2] </td> ";

print "<td> $row[3] </td> ";

print "<td nowrap> $row[4] </td> ";

print "<td> $row[5] </td> ";

print "<td nowrap> $row[6] </td> ";

print "<td> $row[7] </td> ";
print "<td> $row[8] </td>";
print "<td> $row[9] </td> ";
print "<td> $row[10] </td>";
print "<td> $row[11] </td> ";

print "</tr></table></form></body><br><br> ";

anyway, this may be more of a HTML question, I'm not sure. I need the row[10] field to WRAP when printed...this is a pretty long field in my database, and i can't seem to get it to wrap..therefore, that cell when printed out is very long, and makes you have to horizontally scroll...something i'd rather not have to do. How do I go about doing this? Is it even possible?

closer

Try this:

print"<center><hr width=50% height=2><br><h3>Record Number: $row[0]</h3></center>";
print "<table border = 1 valign=center width=100%>
print"<tr bgcolor=\"#CCCCCC\"> <td>Date of Entry</td><td><center>Person who Entered Info<center></td><td><center>Region</center></td>";
print"<td><center>State</center></td><td><center>County</center></td><td><center>Topic</center></td>";
print"<td><center>Product</center></td><td><center>Producer/Credit</center><td><center>Time Scale</center><td><center>Description</center><td><center>Link</center>
</td></tr> ";
print "<td> $row[1]</td> ";
print "<td> $row[2] </td> ";
print "<td> $row[3] </td> ";
print "<td nowrap> $row[4] </td> ";
print "<td> $row[5] </td> ";
print "<td nowrap> $row[6] </td> ";
print "<td> $row[7] </td> ";
print "<td> $row[8] </td>";
print "<td> $row[9] </td> ";
print "<td width=\"150\"> $row[10] </td>";
print "<td> $row[11] </td> ";
print "</tr></table></form></body><br><br> ";

Anon

You may need to set a width value for the table, something like 600 - 800 rather than 100%. Then set the width for the description table cell in the different rows. This may take some trial and error.

You'll also find that there's a missing <tr> and some missing </td>.

You can also clean up the code by using align='center' in each table cell where required.

print"<center><hr width='300' height=2><br><h3>Record Number: $row[0]</h3></center>";
print "<table border='1' valign='center' width='800'>
print"<tr bgcolor='#CCCCCC'> <td align='center'>Date of Entry</td><td align='center'>Person who Entered Info</td><td align='center'>Region</td>";
print"<td>State</td><td align='center'>County</td><td align='center'>Topic</td>";
print"<td align='center'>Product</td><td align='center'>Producer/Credit</td><td align='center'>Time Scale<td align='center' width='100'>Description</td><td align='center'>Link
</td></tr> "; //add in some extra </td> and a width value
print "<tr>"; //missing
print "<td> $row[1]</td> ";
print "<td> $row[2] </td> ";
print "<td> $row[3] </td> ";
print "<td nowrap> $row[4] </td> ";
print "<td> $row[5] </td> ";
print "<td nowrap> $row[6] </td> ";
print "<td> $row[7] </td> ";
print "<td> $row[8] </td>";
print "<td> $row[9] </td> ";
print "<td width='100'> $row[10] </td>"; //add a width value
print "<td> $row[11] </td> ";
print "</tr></table></form></body> "; //remove the <br> tags

Hope this helps

Jon Bertsch

Anon

There's quite a bit here that doesn't need to be "printed" - just stop and start the php using the question and bracket. And consider parsing using a template - phplib or fasttemplate.