本文介绍了将记录分为两列的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我的数据库中有一个学生"表,大约有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>"; ?>更多推荐
将记录分为两列
发布评论