Columns not rows?

[Koutaru]

I know I probably should know how to do this but I just can't get it right ^^;

Anyway, how do you make things display in columns instead of rows? Like after you grab data from the database, your bit template has to be different. Instead of just <tr><td> which will create just rows, how do you make it so there's 4 columns (of images in this case) instead?

Sorry for the confusing explanation.
Thanks! :ninja:

[Jolten]

Add a conditional for the <tr> tags. Like so:


<table width="600" align="center" cellpadding="4" cellspacing="8" class=alt2">
<?
$a=0;
while($row=mysql_fetch_object($XX))
{

-- Variables placed here to call image title, file name in loop --

if ($a == '0') {echo "<tr>";}
if ($a == '4') {echo "</tr><tr>";}
if ($a == '8') {echo "</tr><tr>";}
if ($a == '12') {echo "</tr><tr>";}
if ($a == '16') {echo "</tr><tr>";}
if ($a == '20') {echo "</tr><tr>";}

?>


<td class="alt4" align="center" width="25%" valign="middle">

-- Image code here --

</td>

<?
$a = $a + 1;
}
?>

</table>


Note a is set to ? before the loop. Then the loop increases a with each pass. The conditionals add the closing and opening <tr> tags based upon cycles in the loop. This setup is designed to create 4 table cells before closing a row and opening a new row. The query is designed to only show a maximum of 20 images per page. That's why the conditionals stop at 20. I'm not certain this is the optimum way to do this. But it's been working great for me.

[Koutaru]

Thanks Jolten! I think I've tried doing that but it hasn't worked yet for me. >.> Maybe I did something wrong, but I'll follow your structure.

:)