$keywords_string = ""; $var = $data['news_subject']; $keywords = split(' ', $var); $num_keywords = count($keywords); for ($i=0; $i<$num_keywords; $i++) { if ($i) { $keywords_string .= "OR tf.news_subject LIKE '".$keywords[$i]."%' "; } else { $keywords_string = "tf.news_subject LIKE '%".$keywords[$i]."%' "; } } $result3 = dbquery(" SELECT tf.news_id, tf.news_subject, tf.news_datestamp, u.user_name, u.user_id, u.user_flag FROM ".DB_NEWS." tf LEFT JOIN ".DB_USERS." u ON u.user_id=tf.news_name WHERE (".$keywords_string.") AND tf.news_subject != '".$data['news_subject']."' ORDER BY news_datestamp DESC LIMIT 5 "); echo "\n"; echo "\n\n\n"; echo "\n"; if (dbrows($result3) != 0) { echo "\n"; echo "\n"; echo "\n"; echo "\n"; while($data2 = dbarray($result3)) { $itemsubject = trimlink($data2['news_subject'], 38); echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } } else { echo "\n"; } echo "
Похожие новости
НазваниеДобавилДобавлено
".THEME_BULLET." $itemsubject".profile_link($data2['user_id'], $data2['user_name'])."".showdate("newsdate", $data2['news_datestamp'])."
Нет материалов

\n";