Jump to content


after every foo results, echo bar, then foo more results

  • Please log in to reply
1 reply to this topic

#1 DaveLinger

  • Members
  • PipPipPip
  • Advanced Member
  • 268 posts
  • LocationWV, USA

Posted 22 July 2006 - 11:36 PM

Here's the deal. I'm working on a photo gallery. I want to display the image results in a table... like..

<td>Result 1</td>
<td>Result 2</td>
<td>Result 3</td>
<td>Result 4</td>
<td>Result 5</td>
<td>Result 6</td>

So I can echo the table/tr first easily, but I dont know how to put the /tr then tr after each 3 results

dave at linger dot com

#2 Barand

  • Moderators
  • Sen . ( ile || sei )
  • 18,017 posts

Posted 23 July 2006 - 12:45 AM

Here's an example

define ("NUMCOLS",3);

$res = mysql_query("SELECT col1, col2 FROM mytable");

$count = 0;
echo "<TABLE border=1>";
while (list($col1, $col2) = mysql_fetch_row($res)) {

    if ($count % NUMCOLS == 0) echo "<TR>\n";  # new row

    echo "<TD>$col1<br>$col2</TD>\n";

    if ($count % NUMCOLS == 0) echo "</TR>\n";  # end row

# end row if not already ended

if ($count % NUMCOLS != 0) {
   while ($count++ % NUMCOLS) echo "<td>&nbsp;</td>";
   echo "</TR>\n";
echo "</TABLE>";

If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received


|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users