将记录分为两列

本文介绍了将记录分为两列的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我的数据库中有一个学生"表，大约有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?

显示示例www.freeimagehosting/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>"; ?>