Display results as a grid

[ppsolutions]

I need to display the results from a database query within a table with the first three records in columns 1-3 of the first row of the table, then records 4-6 in the three cells of the second row, records 7-9 in the third row, etc. Does anyone have an easy way of doing this?

[krumms]

assuming mysql:

// $myquery is the SELECT query you're using

$result = @mysql_query( $myquery );

$colcount = 0;

echo "<table>\n";

while( $row = @mysql_fetch_array( $result, MYSQL_ASSOC ) ) {
  if( $colcount % 3 == 0 ) {
    echo "<tr>";
  }

  echo "<td>";

  $data = array();

  foreach( $row as $key => $value ) {
    $data[] = "$key='".stripslashes( $value )."'";
  }

  echo implode( ', ', $data );
  echo "</td>";

  if( $colcount % 3 == 0 ) {
    echo "</tr>";
  }

  $colcount++;
}

Excuse any syntax errors, haven't tested this.

[ppsolutions]

Thanks for that. I had a couple of errors to begin with but got it sorted in the end.