'); return $connection; } // sends a query to MySQL and returns a PHP array function db_query($query) { $return = Array(); $result = mysql_query($query); $x = 0; while($row = mysql_fetch_row($result)) { $return[$x] = $row; $x++; } return $return; } // sends a query to MySQL and returns an associative PHP array function db_query_assoc($query) { $return = Array(); $result = mysql_query($query) or die ("Database Error: $query"); $x = 0; while($row = mysql_fetch_assoc($result)) { $return[$x] = $row; $x++; } return $return; } // search MySQL for a given string, each element separated by "+" function doSearch($string) { $searchArray = explode("+", $string); $result = Array(); $searchString = ""; foreach($searchArray as $key) { $searchString .= "+" . $key . "* "; } $result['events'] = db_query("SELECT cId, title, details FROM events WHERE MATCH (title, details, program) AGAINST ('" . $searchString . "' IN BOOLEAN MODE);"); return $result; } ?>