How do I do this?

Anon

Hi.

How do I make my mysql result show up in a table, with 3 cells per row?
Example:

-------------------------
I 1 I 2 I 3 I
-------------------------
I 4 I 5 I 6 I
-------------------------
I 7 I 8 I 9 I
-------------------------

Thx.

Anon

Woops!
well like:
http://www.cwd.dk

Anon

loop through your result set and use a counter. create a <TR> on start and a <td> for each record and create </tr><tr> when your counter hits 3 then reset the counter and continue then fill your last row with <td> </td> and end with </tr> to end the last row.

Tom

Anon

Okay thx!

Anon

Hope this helps:

$NUMBER_OF_ROWS = 2;
$NUMBER_OF_COLUMNS = 3;

for ($i=0; $i < NUMBER_OF_ROWS; $i++)
{
print("<tr>");
for ($j=1; $j < NUMBER_OF_COLUMNS + 1; $j++)
{
print("<td>Stuff Here!</td>");
}
print("</tr>");
}

That should work, and the output should be something like:

+------+------+------+
|......|......|......|
+------|------|------+
|......|......|......|
+------|------|------+

Will create a 2 row / 3 columned table. Let me know it it works 🙂

--
John Barker

Anon

One things... depending on how complicated the table is (if you are using any kind of colored borders or nesting) this may not turn out right if the number of items does not evenly divide by 3. The problem will likely not exist in Explorer, but in netscape the last row will look funny.

What you can do is make each cell 33%. Then, when you are done your loop... take $Offset=$Counter % 3

Then, of $Offset!=0, make a cell that has width of:
(3-$Offset)*33

This should guarantee that the last row has enough cells... and that they fill out the table.

You may need to add a little additional logic -- but I have got it working on a couple of production sites.