$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 "<table width='100%' cellpadding='0' cellspacing='1' border='0' class='tbl' style='padding: 1em 0em 0.8em 0em;'>\n";
	echo "<tr>\n<td colspan='5' class='forum-caption' style='text-align:left'>Похожие новости</td>\n</tr>\n";
	echo "<tr>\n";
	if (dbrows($result3) != 0) {
    echo "<td class='tbl2' align='center'>Название</td>\n";
	echo "<td class='tbl2' align='center'>Добавил</td>\n";
    echo "<td class='tbl2' align='center'>Добавлено</td>\n";
    echo "</tr>\n";
	    while($data2 = dbarray($result3)) {
	    $itemsubject = trimlink($data2['news_subject'], 38);
	echo "<tr>\n";
    echo "<td width='55%' class='tbl1'>".THEME_BULLET." <a href='".BSFURL.news($data2['news_id'])."' title='".$data2['news_subject']."' class='side'>$itemsubject</a></td>\n";
	echo "<td width='17%' class='tbl1' align='center'>".profile_link($data2['user_id'], $data2['user_name'])."</td>\n";
    echo "<td width='27%' class='tbl1' align='center'>".showdate("newsdate", $data2['news_datestamp'])."</td>\n";
    echo "</tr>\n";	
	    }
	} else { 
	echo "<td class='tbl1' colspan='5' style='text-align:center'>Нет материалов</td></tr>\n"; }
	echo "</table><br>\n";	
 
Добавлено за 0.048 секунд, используя GeSHi 1.0.8.10

 
$keywords = split(' ', $data['news_subject']);
foreach ($keywords as $keyword) {
$keywords_query = $keywords_query && $keywords_query != '' ? $keywords_query."OR tf.news_subject LIKE '".$keyword."%' " : "tf.news_subject LIKE '%".$keyword."%' ";
}
 
Добавлено за 0.017 секунд, используя GeSHi 1.0.8.10

 
foreach (split(' ', $data['news_subject']) as $keyword) {
$keywords_query = $keywords_query && $keywords_query != '' ? $keywords_query."OR tf.news_subject LIKE '".$keyword."%' " : "tf.news_subject LIKE '%".$keyword."%' ";
}
 
Добавлено за 0.022 секунд, используя GeSHi 1.0.8.10