output question

[achai]

if I want get result from database, three records a line.
like:
<tr><td>#1#</td><td>#2#</td><td>#3#</td></tr>
<tr><td>#4#</td><td>#5#</td><td>#6#</td></tr>

how do i write this? use cfloop?
thanks
[sig][/sig]

 

[perichazhi]

<table>
<tr>
<td>First Col</td><td>Second Col</td><td>Third Col</td>
</tr>
<cfoutput query=&quot;qGetResults&quot;>
<tr>
<td>#databasevalues#</td>
<cfif qGetResults.currentrow MOD 3 Is 0>
</tr>
</cfif>

</cfoutput>
</table>
</html>

Hope this works for u,

) Perichazhi [sig][/sig]