HTML Tables

[Anon]

Hi there, OK, my problem is reasonably simple. I know how to create a html table with PHP, and then retrieve code from a mysql database, and put the data into table cells. I need to do this using a "while" loop statement. So what Ive done so far, is I am able to list in a single columned table, all the data in a mysql table, regardless of the number of rows.

Now I am looking for a way in which to do this, but have the data in a four columned table. So the first MSQL row that the sql table has, would be put in to HTML table row 1, column 1. THe next bit of data would co to row 1, column 2, then row 1 column 3 and then row 1, column 4. But the followingpiece of data would have to go to row 2, column 1.

Im stumped....can you please help??

TIA,

Neil.

[tednugent]

Neil-

It sounds as though you need to create the while loop within your TR <tr>, let it count to four (while entering a new TD <td> each time it counts), and then move on to the next TR <tr>. Write back if this is what you're already doing and we'll troubleshoot a little more from there.

-TN

[Anon]

Ted,

Hi, and thanks. I understand what you're saying- and its oudning good, but Im having trouble implementing this...can you help here at all??

Cheers mate,
Neil.

[tednugent]

Neil-

How bout something like this:

<table>
<tr> <!-- First row -->
<?php
$columns = 4;
$i = 1;
while ($i <= $columns)
{
print("<td>enter your biz here<td>\n");
&i++;
}
?>
</tr> <!-- End first row -->
<tr> <!-- Second row -->
<?php
$columns = 4;
$i = 1;
while ($i <= $columns)
{
print("<td>enter your biz here<td>\n");
&i++;
}
?>
</tr> <!-- End second row -->
</table>

You could even automate it to do the same thing with the rows, so you can count the number of rows it goes down. Good luck with it. Let me know if you find any more grief.

-TN