将记录分为两列 [英] Split records into two columns

问题描述

我的数据库中有一个学生"表，大约有5,000条记录.我想在两个 div中显示这些记录.我该如何执行而又不执行两次查询?只使用一个查询?

I have a "student" table, having around 5,000 records, in my DB. I want to display those records in two divs. How do I do that without executing the query twice; only using a single query?

显示示例http://www.freeimagehosting.net/uploads/f1c6bb41eb.gif

推荐答案

只需找到中间"的位置，然后输出div标签的结束标签和第二个div的开始标签:

Just find where the "middle" is and output the end tag of the div tag and the start tag of the second div:

<? 
$rowcount = mysql_num_rows($recordset);
echo "<div id='div1'>";
$i = 0;
while ($d = mysql_fetch_object($recordset)) {
  echo $d->somefield;
  $i++;

  if ($i == floor($rowcount / 2)) {
      //we have reached the mid-point, let's close the first DIV
      echo "</div><div id='div2'>";
  }
}
echo "</div>";
?>

这篇关于将记录分为两列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！