$sql = "select * from dede_archives where id =".$aid." limit 1"; $query = mysql_query($sql); $row = mysql_fetch_array($query); $typeid = $row["typeid"]; $sql = "SELECT * FROM dede_archives where id<>".$aid." and typeid =".$typeid." order by id desc limit 4"; $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']; $litpic = $row["litpic"]; @me.= '

'.$title.'

'; } {/dede:FIELD.aid}