[RESOLVED] Help with an html table using php

[timski72]

Hi there,

I have written a script that outputs a selected record with 6 fields from a mysql table into an html table. The table has 2 rows; the 1st row just has the cell name and the 2nd row contains the data from the table. Each row has 6 columns. It looks a little like this.

Head1 Head2 Head3 Head4 Head5 Head6
Field 1 Field 2 Field3 Field 4 Field 5 Field6

I'd like to format the table as follows:

Head1 Field1 Head4 Field4
Head2 Field2 Head5 Field5
Head3 Field3 Head6 Field6

The parto of code I currently use to create the table is

while($row = mysql_fetch_row($result))
	{
		echo '<tr>';
		echo '<td>' . $row[3]. '</td>';
		echo '<td>' . $row[4] . '</td>';
		echo '<td>' . $row[5] . '</td>';
		echo '<td>' . $row[6] . '</td>';
		echo '<td>' . $row[7] . '</td>';
		echo '<td>' . $row[8] . '</td>';
		echo '</tr>';


}

It's a bit difficult to explain exactly what I mean so I hope it's clear enough.
Any suggestions would be most welcome.
Thanks,
Tim.

[NogDog]

Do you mean something like this?

while($row = mysql_fetch_row($result))
{
   echo "<tr><th>Head 1</th><td>".$row[3]."</td>";
   echo "<th>Head 4<td>".$row[6]."</td></tr>\n";
   echo "<tr><th>Head 2</th><td>".$row[4]."</td>";
   echo "<th>Head 5<td>".$row[7]."</td></tr>\n";
   echo "<tr><th>Head 3</th><td>".$row[5]."</td>";
   echo "<th>Head 6<td>".$row[8]."</td></tr>\n";
}

[garblar]

while($row = mysql_fetch_row($result))
{
   echo "<tr><th>Head 1</th><td>".$row[3]."</td>";
   echo "<th>Head 4</th><td>".$row[6]."</td></tr>\n";
   echo "<tr><th>Head 2</th><td>".$row[4]."</td>";
   echo "<th>Head 5</th><td>".$row[7]."</td></tr>\n";
   echo "<tr><th>Head 3</th><td>".$row[5]."</td>";
   echo "<th>Head 6</th><td>".$row[8]."</td></tr>\n";
} 

[timski72]

That's exactly what I wanted! Thanks.

[rodneykm]

I like to build my tables in standard html and do my echos inside w/ php. Something like....

<?php
while($row = mysql_fetch_row($result))
{ ?>

<table>
<tr>
<td> <?php echo $row[3]; ?> </td>
</tr>
</table>

<?php } ?>

Something like that. Makes it much easier to work with...at least to me.