mysql怎么按单双数结果并类

mysql如何按单双数结果并类？
这是一个分页的代码，每页十条记录，按时间倒序排列。

PHP code

<!--Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->$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

<!--Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->

• 1st result
• 3rd result
• 5th result
• 7th result
• 9th result

• 2nd result
• 4rd result
• 6th result
• 8th result
• 10th result

HTML 视图

HTML code

<!--Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->     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).'

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