/*author：织梦的鱼
*function:检索和当前页面关键字相同的专题页面
*time:2011.07.08
*/
function getlikespc($keywords=0)
{
global $cfg_basehost,$dsql;
$key = array();
$key = explode(“,”,$keywords);
$likesql;
$len =count($key);
for($i=0;$i<$len;$i++){
$now = $len-$i;
if($now==1){
$likesql .= “keywords like ‘%”.$key[$i].”%’ “;
}else{
$likesql .= “keywords like ‘%”.$key[$i].”%’ or “;
}
}//关键字分割检索,拼接 查询语句
$getsql = “SELECT * from idea_archives where idea_archives.channel=’-1′ and $likesql order by idea_archives.id “;//查询与该文章关键字相同的专题
//echo $getsql;
$toback;
$dsql->Execute(“m”,$getsql);
while($row = $dsql->GetObject(‘m’))
{
$title = $row->title;//专题标题
$id = $row->id;//专题ID
$toback = “<a href=’”.$cfg_basehost.”/special/arc-”.$id.”.html’ >”.$title.”</a>”;
}
return $toback;//返回文章链接
}
|