[RESOLVED] cell rows

[Rezznor]

The website I am working on is at http://comedycentral.rezznor.com. While it certainly isn't finished in most areas, there is one area that I don't think I can fix myself, and that is the area displaying current members.

When a member updates his or her information, they attach an image file, and the location of which is stored in a database along with all the other information.
For every member that is in the database, it shows in the Current Characters area. I would like it to display 3 on one row, the next 3 on a second row, and so on.
How can I do this? I tried subtracting 3 from the rowcount, but wasn't sure how the next line would start at 4 through 7, but only if there were that many results being returned. Like, if there are 4 entries, dispaly 1-3 on one line, and 4 on the next, or if there were 8 entries, display 1-3 on one, 4-6 on another, and 7-8 on the last, and so on. After a while I just got a headache.

$query = "SELECT * FROM characters WHERE username = '$name'";
$result = mysql_query ($query);

if ($result)
{
while ($row = mysql_fetch_array($result, MYSQL_NUM))
{
//display all the fields of the table
}
}

[bpat1434]

use the modulus operator to see if the number is divisible by 3 in the loop. IF there is no remainder, start a new row, otherwise continue:

$i=1; // Most crucial part!!
while($row = mysql_fetch_array($result, MYSQL_NUM))
{
  // Display your stuff
  if($i%3==0){ echo '</tr><tr>'; }
  $i++; // Increment the counter
}

[Rezznor]

Huzzah! Thanks. It works.