Creating Dynamic "<td>" table values

[mabans]

Damn I'm just having all kinds of trouble lately. Anyway. I want to be able to display results with according information including images as a side by side view.

// example on how the display should be aligned. Numbers equal result # //

1    2
3    4
5    6
7    8
9    10
11   12

// example on how the display should be aligned. Numbers equal result # //

While I can care this as a straight table and have it list down in a result fashion I would like to do so in a fashion where it's 2 columns down. Thanks in advance

[LordShryku]

Where are you getting the result set from? Are you reading a directory? A database query? Is it going to be in an array?

[mabans]

It will be making a query to a MySQL database, and use arrays for results.

[LordShryku]

Ok, so just an idea here. This is untested, so you may need to tweak it, but it's a concept....

/* SQL Query, blah blah */

$rows = mysql_num_rows($results);
if($rows > 0) {
   /* If we have results, lets do this */

   $break    = 2; // number of cells to break after
   $curbreak = 2; // current number to break at
   $cur      = 0; // counter

   echo "<table>\n";
   echo "<tr>\n"; // start the first row

   while($row=mysql_fetch_array($results)) {
      $cur++; // increment counter
      echo "<td>".$row['blah']."</td>\n";

  if($cur == $curbreak) {
     if($curbreak < $rows) {
        $curbreak += $break; // increment break point
        echo "</tr><tr>\n"; //end row, start new one
     } // otherwise we're done anyway
  }
   }
   echo "</tr></table>";
}