您好,欢迎来到三六零分类信息网!老站,搜索引擎当天收录,欢迎发信息

mysql怎么按单双数结果并类

2025/11/8 16:45:25发布17次查看
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).''>;
------解决方案--------------------
也可通过移动指针完成
该用户其它信息

VIP推荐

免费发布信息,免费发布B2B信息网站平台 - 三六零分类信息网 沪ICP备09012988号-2
企业名录 Product