![]() |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
IP: 114.238.104.73
|
|||
|
|||
|
<?php
$w_total=$empire->fetch1("select count(*) as total from {$dbtbpre}ecms_news where classid=$navclassid"); $total=$w_total[total]; if($total<20) { ?> <strong>Latest US Free Patents</strong> <ul> [e:loop={'SELECT * FROM [!db.pre!]ecms_news AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(id) FROM [!db.pre!]ecms_news)-(SELECT MIN(id) FROM [!db.pre!]ecms_news))+(SELECT MIN(id) FROM [!db.pre!]ecms_news)) AS id) AS t2 WHERE t1.id >= t2.id ORDER BY t1.id LIMIT 30 ',30,24,0}] <li><a href="<?=$bqsr['titleurl']?>" target="_self"><?=$bqr['title']?></a></li> [/e:loop] </ul> <?php } elseif(($total<30)&($total>20)) { ?> <strong>Latest US Free Patents</strong> <ul> [e:loop={'SELECT * FROM [!db.pre!]ecms_news AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(id) FROM [!db.pre!]ecms_news)-(SELECT MIN(id) FROM [!db.pre!]ecms_news))+(SELECT MIN(id) FROM [!db.pre!]ecms_news)) AS id) AS t2 WHERE t1.id >= t2.id ORDER BY t1.id LIMIT 20 ',20,24,0}] <li><a href="<?=$bqsr['titleurl']?>" target="_self"><?=$bqr['title']?></a></li> [/e:loop] </ul> <?php } else { ?> <strong>Latest US Free Patents</strong> <ul> [e:loop={'SELECT * FROM [!db.pre!]ecms_news AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(id) FROM [!db.pre!]ecms_news)-(SELECT MIN(id) FROM [!db.pre!]ecms_news))+(SELECT MIN(id) FROM [!db.pre!]ecms_news)) AS id) AS t2 WHERE t1.id >= t2.id ORDER BY t1.id LIMIT 10 ',10,24,0}] <li><a href="<?=$bqsr['titleurl']?>" target="_self"><?=$bqr['title']?></a></li> [/e:loop] </ul> <?php } ?> 具体演示:http://www.us-patent-search.net 也可这么用: <? if($GLOBALS[navclassid]>71 and $GLOBALS[navclassid]<78 ) {echo '<a href=http://www.xuyidaily.cn/>盱眙新闻网欢迎您!</a>';} else{?>[!--newsnav--] > 正文<? } ?> 具体演示:http/www.xuyidaily.cn Last edited by Galeton : 2015-10-11 at 08:16 AM |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| 帝国cms 灵动标签【列表页】调用当前父栏目下的所有子栏目 | Eakly | 帝国Cms | 0 | 2015-10-06 09:03 AM |
| 帝国cms 灵动标签调用顶级栏目导航 | Mabel | 帝国Cms | 0 | 2015-10-06 08:59 AM |
| 帝国cms 无用的数据表(数据模型)能否删除 | Haddon | 帝国Cms | 0 | 2015-09-26 05:11 AM |
| 帝国cms 建立目录不成功!请检查目录权限 的解决办法 | Pacific City | 帝国Cms | 0 | 2015-09-11 07:14 AM |