listing items from a Mysql DB

[Anon]

I'm trying to set up a table to be generated from a mysql DB to list the items in this manner

item 1 ---- item 2

item 3 ---- item 4

so it should pull the first four results in a loop if 7 items exist then it should look like this

item 1 ---- item 2

item 3 ---- item 4

---

item 5 ---- item 6

item 7

is the a way to list 4 items with a single loop

TIA
Richie TM

[Anon]

This problem is perfectly tailored for a modulus solution.

/
The first thing you'll need to do is
bring the data out of mysql.
/
$res = mysql_query("SELECT item FROM table");
while ($data = mysql_fetch_object($res))
$aItem[count($aItem)] = $data->item;

/
Now you just start looping through this
$aItem array you created. I went ahead
and put HTML in the print statements.
*/

print "<Table border=1>";

for ($i = 0; $i < sizeof($aItem); $i++) {

// this will check to see if we should put a line 
// between our box of 4 items. (except for the first
// box of course).
if ((($i % 4) == 0) && ($i)) {
	print "<Tr><Td colspan=2><hr width=100%></Td></Tr>";
}

if (($i % 2) == 0) {
	// print out a <TR> if it's the
	// start of the four item box
	if ($i == 0)
		print "<Tr>\n\t<Td>$aItem[$i]</Td>\n";
	else
		print "</Tr><Tr>\n\t<Td>$aItem[$i]</Td>\n";      
} else { // just print the item out
	print "\t<Td>$aItem[$i]</Td>\n";
}

}

print "</Table>";

[Anon]

Thanks this was great I really appreciate your help