opentable("Похожие статьи");
$article_id = isnum($data['article_id']) ? $data['article_id'] : 0;
if($article_id){
list($article_subject) = dbarraynum(dbquery("SELECT article_subject from ".DB_ARTICLES." WHERE article_id=".$article_id.""));
$result = dbquery("
SELECT tt.article_id, tt.article_subject, tt.article_datestamp, tt.article_draft, tf.article_cat_id, tf.article_cat_name
FROM ".DB_ARTICLES." tt
INNER JOIN ".DB_ARTICLE_CATS." tf ON tt.article_cat=tf.article_cat_id
WHERE MATCH (article_subject) AGAINST ('".$article_subject."' IN BOOLEAN MODE) AND article_id != ".$article_id." ORDER BY tt.article_datestamp DESC LIMIT 4"
);
if(dbrows($result)){
$i = 0;
while($data = dbarray($result)){
$itemsubject = trimlink($data['article_subject'], 40);
echo "· ".$itemsubject."
\n";
}
} else {
echo "Нет похожих статей";
}
closetable();