Re: Re: Making a new row in HTML tables

Hmmm. No code, but I'm guessing you'll probably want to set the width of the table to be int(sqrt(mysql_num_rows($results))), and then set up your loops to place only that amount of cells across. Then just keep going til you run out of data. So in the example of 31, you'd set the number of columns to be 5 (int(sqrt(31))), and then create a nested loop to go through your data. Hmmm. Maybe I will write some code... :) $numdata = mysql_num_rows($results); $cols = int(sqrt($numdata)); // This figures out how many $rows = $cols + ceil(($numdata-($cols*$cols))/$cols); echo "<table>"; for ($i=1; $i<=$rows; $i++) { echo "<tr>"; for ($j=1; $j<=$cols; $j++) { echo "<td>"; $row = mysql_fetch_array($results); echo $row['name']; echo "</td>"; } echo "</tr>"; } echo "</table>"; Not tested, but I bet it works :) Ian Grant wrote: > > Yeah, but if I had 31, > I'd want 6x5 and then 1 over, or something.... > > Hugh Bothwell <hugh_bothwell@hotmail.com> wrote in message > news:20010725161627.68874.qmail@pb1.pair.com... > > Umm... 31 entries, 1 x 31... > > > > You might be better to choose a standard width and pad the last row with > > empty cells. > > > > "Ian Grant" <ian.grant@btinternet.com> wrote in message > > news:20010725154701.44170.qmail@pb1.pair.com... > > > Hi, > > > > > > Can anyone help me with this - I have a database of people, that I want > to > > > print into an HTML table - how can I make the table wrap into an equal > > > number of rows. > > > i.e. if there are 4 entries, a 2x2 table, 6 a 2x3, 8 a 2x4, 9 a 3x3, > etc. > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- Chris Hobbs Silver Valley Unified School District Head geek: Technology Services Coordinator webmaster: http://www.silvervalley.k12.ca.us/~chobbs/ postmaster: chobbs@silvervalley.k12.ca.us