dynamic table generation

Anon

I have a table with the following columns:

countryID countryname countrycode

I want to create a table of X rows with 7 columns containing each countryname seperated by ~ until the end of the table.

EX.

united states ~ canada ~ china ~ ....... ~ chile
cuba ~ .... etc.

The problem I am having, how do I set the number of entries PER ROW before going to the next one (i.e. insert seven countrynames then <TR> then seven more).

SAMPLE CODE:
This obviously doesn't work but suggestions are appreciated.

<?php
print "<TABLE width=\"660\" ALIGN=\"CENTER\">";
$query = mysql_query("SELECT * FROM country WHERE countrycode != 'US' AND countrycode != 'CA'",$db);
$i = 0;
while($i < 7,$result[$i] = mysql_fetch_array($query),$i++) {
print "<TR><TD>$result[$i]</TD></TR>";
$i++;
}
print "</TABLE>";
?>

TIA,
/frank

Anon

Here's my code from http://db.etree.org/etree_shncirc.php

foreach(shn::getArtists(true) as $url => $name) {
echo "<TD class=tabledetail><A HREF=\"$url\">$name</a>";
echo "</A></TD>";
$i++;
if ($i == 5) {
	echo "</TR>";
	$i = 0;
};
};

The only thing wrong with it is I don't fill up the last row...not a hard thing to do, but I haven't taken the time yet.

Anon

foreach(shn::getArtists(true) as $url => $name)

so this dumps the contents of the 'getArtists' column into the variable $name on each pass through the array?

I modified it a little to the following, but it is dumping out each column of each row into one line... still playing with it though.

print "<TABLE width=\"660\" ALIGN=\"CENTER\">";
$query = mysql_query("SELECT * FROM country WHERE countrycode != 'US' AND count
rycode != 'CA'",$db);
$i = 0;
while($result = mysql_fetch_array($query)) {

foreach($result as $temp) {
$name = $result[countrycode];
print "<TR><TD><A HREF=\"/rivers/$name\">$temp</A> ~</TD>";
$i++;
if ($i == 8) {
print "</TR>";
$i = 0;
}

}
}

thanks,
/frank