mysql怎么按单双数结果并类

程序员文章站 2022-05-11 20:49:50

...

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==0){ echo '

最后我想输出的结果是

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 "

".implode("",$left).''>; echo "

".implode("",$right).''>;
------解决方案--------------------
也可通过移动指针完成

声明：本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn核实处理。