3 records across

chrisleon

This might be the dumbest question I have asked on this forum, but I need to know of a way to query a DB, and print the records across the screen 3 at a time. I always print downwards, but I am being asked to print 3 records, then break, 3 records then break, I am not sure how to do this. Any help would be much appreciated.

Installer

One way is to keep a count, incrementing for each record. When it reaches three, reset the count and start a new row.

A forum search should turn up other ways to do it.

atokatim

try this :

$count=0;
$sql = mysql_query("Select * from ....");
while($result = mysql_fetch_object($sql)){
  $count++;
  echo $result->some_row." | ";
  if($count==3) { $count=0; echo "<br>";
}

bradgrafelman

Note that atokatim has a missing } in his code (to close the last if() statement) if you use his suggestion.

Another possiblity is the modulo operator:

for($i = 0; $result = mysql_fetch_object($sql); $i++) {
    echo $result->some_row . " | ";
    if($i % 3 == 0)
        echo "<br/>\n";
}

EDIT: Just because I wanted to refresh my knowledge, I tried to make some code that outputted the data in a <table> form... can't seem to condense it down any more than this:

echo "<table>\n";
for($i = 0; $result = mysql_fetch_object($sql); $i++) {
  if($i == 0)
      echo "<tr>\n";
  elseif($i % 3 == 0) // change the 3 to suit # of columns
      echo "</tr>\n<tr>\n";
  echo '<td>' . $result->some_row . "</td>\n";
}
while($i % 3 != 0) { // the 3 should be the same # as above
	echo "<td>&nbsp;</td>\n";
	$i++;
}
echo "</tr>\n</table>";