PHP基础PHP教程php框架JavaScript

asp.netAJAX正则表达式ASP

输入banner图图片脚本导航/分类

mysql怎么按单双数结果并类

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 "
      ".implode("",$left).';
echo "
        ".implode("",$right).';

        ------解决方案--------------------
        也可通过移动指针完成