作者:c肀xc86_441 | 来源:互联网 | 2014-03-27 08:08
mysql如何按单双数结果并类?这是一个分页的代码,每页十条记录,按时间倒序排列。PHPcode$sql=mysql_query("SELECT*FROMarticleWHEREuid='132828'ORDERBYdat
mysql如何按单双数结果并类?
这是一个分页的代码,每页十条记录,按时间倒序排列。
PHP code
$sql = mysql_query("SELECT * FROM article WHERE uid='132828' ORDER BY date LIMIT ".$number.",10 ");
$num = 1;
while($row = mysql_fetch_array($sql)){
if($num ==1){
echo '
';
}
if($num ==5){
echo '';
}
//这里的代码如何写,才能按单双数并类?
if($num%5==0){
echo '
';
}
$num++;
}
最后我想输出的结果是
HTML code
- 1st result
- 3rd result
- 5th result
- 7th result
- 9th result
- 2nd result
- 4rd result
- 6th result
- 8th result
- 10th result
HTML 视图
HTML code
ul ul
------------ ------------
| 1st result | 2nd result |
------------ ------------
| 3rd result | 4th result |
------------ ------------
| 5th result | 6th result |
------------ ------------
| 7th result | 8th result |
------------ ------------
| 9th result | 10th result|
------------ ------------
------解决方案--------------------
PHP code
$num = 1;
while($row = mysql_fetch_array($sql)){
if($num % 2)
{
$left[] = '
'.$row['title'].'';
}
else $right[] = '
'.$row['title'].'';
}
echo "
;
echo "
;
------解决方案--------------------也可通过移动指针完成