mysql怎么按单双数结果并类

WBOY
Release: 2016-06-13 13:44:39
Original
1411 people have browsed it

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 '
Copy after login
    '; } if($num ==5){ echo '
      '; } //这里的代码如何写,才能按单双数并类? if($num%5==0){ echo '
    '; } $num++; }


最后我想输出的结果是

HTML code
<!--

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/

-->
Copy after login
  • 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|
 ------------ ------------

Copy after login



------解决方案--------------------
PHP code
$num = 1;
while($row = mysql_fetch_array($sql)){
   if($num % 2)
   {
     $left[] = '
Copy after login
  • '.$row['title'].'
  • '; } else $right[] = '
  • '.$row['title'].'
  • '; } echo "
      ".implode("",$left).'
    '>; echo "
      ".implode("",$right).'
    '>;
    ------解决方案--------------------
    也可通过移动指针完成
    Related labels:
    source:php.cn
    Statement of this Website
    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
    Popular Tutorials
    More>
    Latest Downloads
    More>
    Web Effects
    Website Source Code
    Website Materials
    Front End Template