I am trying to print out rows from a MySQL Database, I want all columns except one on one line and the Messages column on another line, i have managed to do that, but i cannot get the Messages row to extend the full width of the page, here is the code i am using:
Code: Select all
echo " This is a list of completed tasks.";
echo "<table width=100%, border=2>";
echo "<table width=100%, border=2>";
while ($i < $num)
{
$ID=mysql_result($result,$i,"ID");
$Name1=mysql_result($result,$i,"Name1");
$Name2=mysql_result($result,$i,"Name2");
$Company=mysql_result($result,$i,"Company");
$Telephone=mysql_result($result,$i,"Telephone");
$Message=mysql_result($result,$i,"Message");
$Date=mysql_result($result,$i,"Date");
echo "<td width=2%>$ID</td><td width=8%>$Name1</td><td width=12%>$Name2</td><td width=8%>$Company</td><td width=10%>$Telephone</td><td width=10%>$Date</td></tr>";
echo "<td width=80%>$Message</td></tr>";
$i++;
}
echo "</table>";
echo "</table>";
?>__________________________________________________________
l l l l l
6 l Mr Bloggs l 012312325452 l 10/10/2006 l ACME l
_________l________________________________________________l
l
Call back l
regarding l
the order l
for replace l
ment stock l
_________l______________________________________________
and i would like t to look like this:
_________________________________________________________
6 l Mr Bloggs l 012312325452 l 10/10/2006 l ACME
_________________________________________________________
Call back regarding the order for replacement stock
_________________________________________________________
Anyone any ides????
Thanks