How do I put array into columns
$db = mysql_con开发者_StackOverflow中文版nect("", "", "") or die("Could not connect.");
mysql_select_db("",$db)or die(mysql_error());
$sql = "SELECT * FROM table where 1";
$pager = new pager($sql,'page',6);
while($row = mysql_fetch_array($pager->result))
{
echo $row['persons']."<br>";
}
mysql_close($db);
above code output :
Mathew
Thomas John Stewart Watson KelvinWhat I need is it should split inot multiple columns say:
Mathew Stewart
Thomas Watson John KelvinHOw do I do this??
$i = 0;
$columnCount = 2;
echo '<table>';
while($row = mysql_fetch_array($pager->result))
{
$newRow = ( $i % $columnCount == 0 );
if( $newRow ) {
echo '<tr>';
}
echo '<td>' . $row['persons'] . '</td>';
if( $newRow ) {
echo '</tr>';
}
$i++;
}
echo '</table>';
精彩评论