Split Search results into columns

[e1seix]

For example, if i were to call a search from mysql database that's particularly long, what php code could i use to split the results into, say, three separate columns within a single table, without repetition ie. i don't want the "if" statement to just repeat itself three times

[Twey]

Hmm... <table>
<tr>
<?php for($i = 0; $row = mysql_fetch_array($rs); ++$i) { ?>
<?php if($i % 3 === 0) { ?>
</tr>
<tr>
<?php } ?>
<td>
<?php echo($row['data']); ?>
</td>
<?php } ?>
</tr>
</table>You get an extra row at the beginning and end of the table, but it's as neat as I can make it, I think. You could, of course, take care of the extra rows with another two if blocks.