Tables in PHP

[kaen]

Okay, I want a table with 3 rows and 4 columns. But, I don't know how to code that with a while array since I end up having a strange code with multiple <tr>'s and <td>'s. How do I make it so that it has a <tr> after 4 columns yet continues to increase in ID?

[Pig]

$result = mysql_query("SOME SQL HERE");
if( mysql_num_rows($result) > 0 )
     {
     echo("
          <table>
               <tr>
                    <td>col1</td>
                    <td>col2</td>
                    <td>col3</td>
                    <td>col4</td>
               </tr>
          ");
     }
while( $row = mysql_fetch_array($result) )
     {
     echo("
          <tr>
               <td>$row[0]</td>
               <td>$row[1]</td>
               <td>$row[2]</td>
               <td>$row[3]</td>
          </tr>
          ");
     }
if( mysql_num_rows($result) > 0 )
     {
     echo("</table>");
     }

[kaen]

So, if I do that, my table will kind of look like this after parsing?:

<table border="0">
<tr>
<td>image 1</td>
<td>image 2</td>
<td>image 3</td>
<td>image 4</td>
</tr>

<tr>
<td>image 5</td>
<td>image 6</td>
<td>image 7</td>
<td>image 8</td>
</tr>

<tr>
<td>image 9</td>
<td>image 10</td>
<td>image 11</td>
<td>image 12</td>
</tr>

</table>

[Pig]

I assumed that you wanted column headers, so it would look more like:

<table>

<tr>
<td>column name 1</td>
<td>column name 2</td>
<td>column name 3</td>
<td>column name 4</td>
</tr>

<tr>
<td>image 1</td>
<td>image 2</td>
<td>image 3</td>
<td>image 4</td>
</tr>

<tr>
<td>image 5</td>
<td>image 6</td>
<td>image 7</td>
<td>image 8</td>
</tr>

<tr>
<td>image 9</td>
<td>image 10</td>
<td>image 11</td>
<td>image 12</td>
</tr>

</table>

[kaen]

Thanks for your help, but just wondering...in that code- where does it increment the id? It goes up to row[3], but does it continue incrementing?

[Pig]

row[#] refers to the column name, not the row name. By doing the
while( $row = mysql_fetch_array)
you are creating a loop that automatically increments the record. every row gets the row[#] stuff.