Code: Select all
$search = mysql_real_escape_string($_GET['search']);
mysql_select_db($database_db_connect, $db_connect);
$query_basic = "SELECT *, MATCH(name, keywords) AGAINST ('$search' IN BOOLEAN MODE) AS relevance FROM businesses WHERE MATCH(name, keywords) AGAINST ('$search' IN BOOLEAN MODE) and level='1' group by address1 order by relevance DESC";
$basic = mysql_query($query_basic, $db_connect) or die(mysql_error());
$row_basic = mysql_fetch_assoc($basic);
$totalRows_basic = mysql_num_rows($basic);
Thanks in advance for help