Home  >  Article  >  Backend Development  >  mysql怎么按单双数结果并类

mysql怎么按单双数结果并类

WBOY
WBOYOriginal
2016-06-13 13:44:391412browse

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).'
    '>;
    ------解决方案--------------------
    也可通过移动指针完成
    Statement:
    The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn