opentable("Похожие новости");
$news_id = isnum($data['news_id']) ? $data['news_id'] : 0;
if($news_id){
list($news_subject) = dbarraynum(dbquery("SELECT news_subject from ".DB_NEWS." WHERE news_id=".$news_id.""));
$result = dbquery("
SELECT tt.news_id, tt.news_subject, tt.news_visibility, tt.news_datestamp, tt.news_draft, tf.news_cat_id, tf.news_cat_name
FROM ".DB_NEWS." tt
INNER JOIN ".DB_NEWS_CATS." tf ON tt.news_cat=tf.news_cat_id
WHERE MATCH (news_subject) AGAINST ('".$news_subject."' IN BOOLEAN MODE) AND news_id != ".$news_id." ORDER BY tt.news_sticky DESC, tt.news_datestamp DESC LIMIT 4"
);
if(dbrows($result)){
$i = 0;
while($data = dbarray($result)){
$itemsubject = trimlink($data['news_subject'], 40);
echo "· ".$itemsubject."
\n";
}
} else {
echo "Нет похожих новостей";
}
closetable();