<cfoutput query> and TABLE formatting

[flashrx]

HI, I'm trying to output images from a database using <cfoutput query>. That
part works fine. But the images display all in one column, one underneath the
other. I want to get them to display 2 next to each other, then go to the next
table row, display two more, and so on, until all images are displayed. I
can't seem to figure out how to do this. The code I have below outputs
duplicate images next to each other instead one after the other...anyone know
how to do this?

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<cfoutput query="myCenterCategories">
<tr>
<td><img src="#myCenterCategories.categoryImage#"></td>
<td><img src="#myCenterCategories.categoryImage#"></td>
</tr>
<tr>
<td>#myCenterCategories.category#</td>
<td>#myCenterCategories.category#</td>
</tr>
<tr>
<td>#myCenterCategories.categoryPrice#</td>
<td>#myCenterCategories.categoryPrice#</td>
</tr>
<tr>
<td>#myCenterCategories.categoryDescription#</td>
<td>#myCenterCategories.categoryDescription#</td>
</tr>
</cfoutput>
</table>

It's obvious to tell why my images are DUPLICATING from the above code...but
that's the DISPLAY format I want. How do I get 2 records next to each other
and then go to the next row automatcially and display two more records....and
so on?

[TA-Selene]

You need to determine dynamically when to begin/end the rows: <table
width='100%' border='0' cellspacing='0' cellpadding='0'> <cfoutput
query='myCenterCategories'> <cfif CurrentRow MOD 2 EQ 1> <tr> </cfif> <td><img
src='#myCenterCategories.categoryImage#'></td> <td><img
src='#myCenterCategories.categoryImage#'></td> <cfif CurrentRow MOD 2 EQ 0>
</tr> </cfif> <cfif CurrentRow MOD 2 EQ 1> <tr> </cfif>
<td>#myCenterCategories.category#</td> <td>#myCenterCategories.category#</td>
<cfif CurrentRow MOD 2 EQ 0> </tr> </cfif> <cfif CurrentRow MOD 2 EQ 1> <tr>
</cfif> <td>#myCenterCategories.categoryPrice#</td>
<td>#myCenterCategories.categoryPrice#</td> <cfif CurrentRow MOD 2 EQ 0> </tr>
</cfif> <cfif CurrentRow MOD 2 EQ 1> <tr> </cfif>
<td>#myCenterCategories.categoryDescription#</td>
<td>#myCenterCategories.categoryDescription#</td> <cfif CurrentRow MOD 2 EQ 0>
</tr> </cfif> </cfoutput> <cfif myCenterCategories.RecordCount MOD 2 EQ 1>
<td></td> <td></td> <td></td> </td> </cfif> </table>