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();