Displaying data from a database in a table

[gamew0rld]

I have a simple code that grabs the ID and Name of about 400 games listed in the database. Below is the code. As you can imagine, the list is very long. To make it easier, I have made it so every other record is bold. However, instead of the page being 400 lines long, I want it to have 4 games per row and 100 rows in a table to shorten the length of the page. I have tried many things, and am not sure if I should do it like I did with the bold font. Any help would be appreciated.

<?php
include("common.php");
	mysql_connect($Host, $User, $Pass)
		or
	 die("could not connect");
	mysql_select_db($DB);
	$result = mysql_query("SELECT id, name FROM Games");
	while ($row = mysql_fetch_array($result)) 
	{
  $bold=$bold+1;
  	if ($bold==1)
  		{
		printf ("<b>ID: %s  Name: %s </b><br>", $row[0], $row["name"]);
		    }
else
                {
		printf ("ID: %s  Name: %s <br>", $row[0], $row["name"]);
		$bold=0;
	}
}
	mysql_free_result($result);
?>

[Mordecai]

This should work:

while ($row = mysql_fetch_array($result)) {
  $bold += 1; // increment bold value
  $cellnum += 1; // increment the cell number
  if ($bold % 2 == 0) { // not bold
    printf ("ID: %s Name: %s<br>", $row[0], $row["name"]);
  }
  else { // bold
printf ("<b>ID: %s Name: %s</b><br>", $row[0], $row["name"]);
  }
  if ($cellnum % 4 == 0) { // If it is the last cell in the row
    echo("</td></tr><tr><td>"); // Create a new row and a new cell.
  }
  else {
    echo("</td><td>"); // Just create a new cell.
  }
}

Tell me if you encounter any errors. Note that I used the mod (%) operator a lot. This simply divides and returns the remainder.

[gamew0rld]

Yes that works (when I first tried it didnt, but then I realized I didnt put <table> in, lol). The only thing is that the first and 3rd column is bold, and the 2nd and 4th is not. How do I alternate rows?

By the way, Thanks a lot for your help and quick response. 🙂