织梦dedecms在文章页调用同一栏目下的其他文章（不包含本文章）

 

{dede:field.aid runphp='yes'}

$aid = @me;

$sql = "s elect * from dede_archives where id =".$aid." limit 1";

$query = mysql_query($sql);

$row = mysql_fetch_array($query);

$typeid = $row["typeid"];

$sql = "S ELECT * FROM dede_archives where id<>".$aid." and typeid =".$typeid." order by id desc limit 10";

$query = mysql_query($sql);

@me = "";

while($row = mysql_fetch_array($query)){

$id = $row["id"];

$title = cn_substr($row["title"],80,0);

$urlarray = GetOneArchive($id);

$url = $urlarray['arcurl'];

 $pic = $urlarray['litpic'];

@me.= '<li><a href="'.$url.'" title="'.$title.'"  target="_blank"><img alt="'.$title.'"  src="'.$pic.'" />'.$title.'</a></li>';

 

}

{/dede:field.aid}