[SOLVED] How to echo in a loop

[forcom]

$ctryfrom = "SELECT DISTINCT country FROM table";

$ctry = mysql_query($ctryfrom);

 

while($row = mysql_fetch_assoc($ctry)){

$countrynames = $row['country'];

 

echo '<table><tr><td>';

echo "$countrynames";

 

//How can I set the loop to echo </td></tr><tr><td> ten loops to add another column in the table.

            }

 

[Ken2k7]

You'll need a counter.

 

<?php
$ctryfrom = "SELECT DISTINCT country FROM table";
$ctry = mysql_query($ctryfrom);

echo '<table><tr><td>';

$counter = 0;
while($row = mysql_fetch_assoc($ctry)) {
     echo $row['country'];
     if (++$counter % 10 === 0) echo '</td></tr><tr><td>';
}

echo '</td></tr></table>';