$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||||
Название | \n"; echo "Добавил | \n"; echo "Добавлено | \n"; echo "||
".THEME_BULLET." $itemsubject | \n"; echo "".profile_link($data2['user_id'], $data2['user_name'])." | \n"; echo "".showdate("newsdate", $data2['news_datestamp'])." | \n"; echo "Нет материалов | \n"; } echo "