[!--title--]
[]：[!--writer--]
query("select * from {$dbtbpre}ecms_mingju where gsfrom='$navinfor[title]' and writer='$navinfor[writer]'");
while($r=$empire->fetch($sql)){
$navinfor[smalltext]=str_replace($r['title'],'
'.$r['title'].'',$navinfor[smalltext]);
}
echo $navinfor[smalltext];
?>
[!--title--]创作背景
[!--bj--]
[e:loop={'selfinfo',1,0,0,'id<'.$navinfor[id].'','id desc'}]
上一首：《》
[/e:loop]
[e:loop={'selfinfo',1,0,0,'id>'.$navinfor[id].'','id asc'}]
下一首：《》
[/e:loop]
query("select * from {$dbtbpre}ecms_article where classid='$navinfor[classid]' and id<>'$navinfor[id]' order by id desc limit 6");
$sql=$empire->query("SELECT id FROM {$dbtbpre}ecms_article_index WHERE classid='$navinfor[classid]' and id >= ((SELECT MAX(id) FROM {$dbtbpre}ecms_article_index where classid='$navinfor[classid]')-(SELECT MIN(id) FROM {$dbtbpre}ecms_article_index where classid='$navinfor[classid]')) * RAND() + (SELECT MIN(id) FROM {$dbtbpre}ecms_article_index where classid='$navinfor[classid]') ORDER BY id limit 6");
while($rs=$empire->fetch($sql)){
$r=$empire->fetch1("select * from {$dbtbpre}ecms_article where id='$rs[id]' limit 1");
$zj=$empire->fetch1("select ttid,title,titleurl from {$dbtbpre}ecms_sinfo where title='$r[writer]' limit 1");
$ttinfo=$empire->fetch1("select * from {$dbtbpre}enewsinfotype where typeid='$zj[ttid]' limit 1");
$fr=$empire->fetch1("select infotags from {$dbtbpre}ecms_article_data_1 where id='$r[id]' limit 1");
$infotags=$fr['infotags'];//这个就是infotags字段内容
if($infotags){
$tag='';
$t=explode(',',$infotags);//去逗号
$d=count($t);
for($i=0;$i
fetch1("select tagid from {$dbtbpre}enewstags where tagname='$t[$i]' limit 1");
$tagslink="/e/tags/?tagname=".$t[$i];
$tag.="".$t[$i]." ";
}
}
$tagsinfor=''.$tag.'
';
}else{$tagsinfor='';}
?>