织梦获取与当前短标题一样有关的文章

/**

*dede调取和当前文章短标题相同的文章

*/

function s_title($shorttitle)

{

$sql = "SELECT a.shorttitle, b.* FROM dede_archives AS a INNER JOIN  dede_archives as b ON a.id =  b.id  WHERE a.shorttitle='$shorttitle';"

    $dsql->SetQuery($sql);

    $dsql->Execute('t');

    $result = '';

    while($row = $dsql->GetArray('t'))

    {

        $arcrow = GetOneArchive($row['id']);

        $row['arcurl'] = $arcrow['arcurl'];

        $title = cn_substr($row['title'],8);

$result .= "<a href=\"{$row['arcurl']}\">{$title}</a>";

    }

    return $result;

}

{dede:field.shorttitle function="s_title(@me)"/}