<?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