2 columns of data

[penguinspeaks]

I have a table that I want data in. The data will be from a database and sorted by id. Here is the
raw table and how I want it to display.

<table align="center" cellspacing="5" class="auto-style1">
	<tr>
		<td>Player 1</td>
		<td>VS</td>
		<td>Player 2</td>
	</tr>
	<tr>
		<td>1</td>
		<td>&nbsp;</td>
		<td>2</td>
	</tr>
	<tr>
		<td>3</td>
		<td>&nbsp;</td>
		<td>4</td>
	</tr>
	<tr>
		<td>5</td>
		<td>&nbsp;</td>
		<td>6</td>
	</tr>
	<tr>
		<td>7</td>
		<td>&nbsp;</td>
		<td>8</td>
	</tr>
	<tr>
		<td>9</td>
		<td>&nbsp;</td>
		<td>10</td>
	</tr>
	<tr>
		<td>11</td>
		<td>&nbsp;</td>
		<td>12</td>
	</tr>
	<tr>
		<td>13</td>
		<td>&nbsp;</td>
		<td>14</td>
	</tr>
	<tr>
		<td>15</td>
		<td>&nbsp;</td>
		<td>16</td>
	</tr>
	<tr>
		<td>17</td>
		<td>&nbsp;</td>
		<td>18</td>
	</tr>
</table>

The numbers represent id field.
I am all too familiar with displaying rows but I have never tried displaying across two columns.
I have read about using mod 2 but I am just not grasping how to implement it into a table.
I know I start with

numcols = 2

My id code is

 rs("PNAME")

Or maybe it should by a 3 because of the VS column??
What I am doing is displaying the PNAME based on the id.
Can anyone point me in the right direction??

Thanks,
Penguin
Please keep in mind that I am using classic ASP with MySQL database. Not sure if that information helps or not.