Database Display - How can I repete the rows both ways?

[heartless]

I am able to display my database on my webpages either all vertically one after
another ( after using the repete region feature ) or all Horizontally - What i
want to do is my data to be displayed horizontally in my table ( 3 spaces )
and then go down to the next row and then display 3 more and then same thing
over and over ??? can anyone help me>

[jdeline]

You need to create a table that will contain three cells per row. Run a
counter to let you know when you have written the third cell, then create a new
row. See concept code below.

<CFQUERY NAME="getStuff" ... >
SELECT foo FROM myTable WHERE ...
</CFQUERY>

<!--- initialize the cell counter --->
<CFSET i = 0>
<TABLE>
<CFOUTPUT QUERY="getStuff">
<CFIF i MOD 3 IS 0>
<TR>
</CFIF>
<TD>#foo#</TD>
<CFSET i = i + 1>
<CFIF i MOD 3 IS 0>
</TR>
</CFIF>
</CFOUTPUT>
</TABLE>

[Dan Bracuk]

Right general idea but the specifics need a bit of work. First, you can use
the currentrow variable to decrease the amount of code you use.

More importantly, you have to make sure you always have an opening <tr> tag,
so it goes before the cfouput tag. Plus you have ensure you always have a
closing tag.

Something like
<table><tr>
<cfoutput query ="abc">
<td>#xyz#</td>
<cfif currentrow mod 3 is 0>
</tr><tr>
<cfif>
</cfoutput>
</tr>
</table>

[heartless]

Thank you both! I will Try thsi and let you know how i did ....
:-)