Results Table w/ Static Cell

[dsol828]

Hello all,

I am trying to show the results of a mysql query in a regular HTML table but using a bit of PHP to solve this one problem I have.

The table is three cells across, but I want the top right cell to be static HTML content.
Here is the code I have so far, although it won't give me that alternate cell content, as it is now....

What I want:
[result1][result2][CONTENT]
[result3][result4][result5]
[result6][result7][result8]
...etc...

$row = 0;
$column = 0;
echo "<table>";
while($row = mysql_fetch_assoc($result)) {
    if ($column == 0) {echo "<tr>";}
    if (($column == 2) && ($row == 0)){echo "<td>content</td></tr><tr>";}
  echo "<td>".$row['business']."</td>";
  $column++;
  if ($column >= 3) {
    $row++;
    echo "</tr>";
    $column = 0;
  }
}
echo "</table>";

Anyone have any ideas of how to accomplish this?
Thanks in advance!

[Weedpacket]

[man]array_splice[/man]; don't take anything out at that position (offset=2, length=0), but insert a (one-element) array containing the static content in the appropriate position (replacement=array(CONTENT)).

Obviously, you'd need to read all the rows from the result set into an array first - but I always do that anyway, because an array is easier to work with (see previous paragraph).

[NogDog]

And once you have everything in an array, you can use [man]array_chunk/man to create an array of arrays (in this case using 3 for the second parameter since you want 3 columns). Then you can do a foreach() loop on the top-level of that array for the rows with an internal foreach() on the 2nd-level for the columns.