factoring2117 Posted December 17, 2009 Share Posted December 17, 2009 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? Quote Link to comment https://forums.phpfreaks.com/topic/185537-problem-selecting-multiple-groups-of-a-certain-column/ Share on other sites More sharing options...
Buddski Posted December 18, 2009 Share Posted December 18, 2009 $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.. Quote Link to comment https://forums.phpfreaks.com/topic/185537-problem-selecting-multiple-groups-of-a-certain-column/#findComment-979574 Share on other sites More sharing options...
sasa Posted December 18, 2009 Share Posted December 18, 2009 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>'; ?> Quote Link to comment https://forums.phpfreaks.com/topic/185537-problem-selecting-multiple-groups-of-a-certain-column/#findComment-979666 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.