Доработка. Поиск клубов

	cmsCore::loadModel('clubs');
	$model = new cms_model_clubs();

/////// поиск по клубам		//////////
 
	$sql = "SELECT id, title, description
	FROM cms_clubs 
	WHERE MATCH(title, description) AGAINST ('$query' IN BOOLEAN MODE) AND published = 1 LIMIT 100";
 
$result = $inDB->query($sql);
 
if ($inDB->num_rows($result)){
	while($item = $inDB->fetch_assoc($result)){
 
		$result_array = array();
		$result_array['link']        = "/clubs/".$item['id']."";
		$result_array['place']       = ' «'.$item['title'].'»';
		$result_array['description'] = $searchModel->getProposalWithSearchWord($item['description']);
		$result_array['title']       = $item['title'];
		$result_array['session_id']  = session_id();
 
		$searchModel->addResult($result_array);
	}
}