Problem Selecting Multiple Groups of a Certain Column

[factoring2117]

Ok, here is what I am trying to accomplish.

 

I have a table with 1000 names in it and I need to display 50 names in each div. It should look something like this:

 

<div id="some_div">name,name,name,ect...</div>          // next div                    <div id="some_div"> name,name,name,ect....</div>

 

So the code would be something like this:

 

$sql = mysql_query("SELECT * FROM name_table");
echo '<div id="some_div">';
while($row = mysql_fetch_array($sql)) {
      echo $row['name'].',';
}
echo '<div>';

         

 

The issue is that this code will just put all the names into one div. I need the names divided into 20 divs with 50 names in each div.

 

Any idea's?

 

 

[Buddski]

$sql = mysql_query("SELECT * FROM name_table");
echo '<div id="some_div">';
$i = 1;
while($row = mysql_fetch_array($sql)) {
      echo ($i%50 ? $row['name'].',' : '</div><div id="some_div">'.$row['name']);
$i++
}
echo '<div>';

 

Or something..

[sasa]

or

<?php
$sql = mysql_query("SELECT * FROM name_table");
$i = 0;
while($row = mysql_fetch_array($sql)) {
if ($i++ == 0) echo "<div>";
    echo $row['name'];
    if ($i < 50){
    	echo ', ';
    } else {
    	echo '</div>';
    	$i = 0;
    }
}
if ($i > 0) echo '</div>';
?>