开发者

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

Kelvin

What I need is it should split inot multiple columns say:

Mathew   Stewart

Thomas   Watson

John   Kelvin

HOw 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>';
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜