WHAT ARE YOU THINKING ABOUT RIGHT NOW?

// Base queries for searching with each search word
$SearchQueryBase = "SELECT $RetrieveRows, 1 AS Matches
					FROM RE_Homes
					WHERE SearchString LIKE '%s'
					AND $ProvinceCodeSearch
					AND $RefineSearch";
// The combined built search queries
$SearchQueries = "";
// Base query to execute all individual search queries and combine the results
$SearchQuery = "SELECT SQL_CALC_FOUND_ROWS $RetrieveRows, COUNT(Matches) AS TotalMatches FROM (%s) AS SearchResults GROUP BY HomeID ".$SortBy." ".$Limit;

// Find all matches for each search word
for($i = 0; $i < count($SearchArray); $i++) {
	// Build the search query using a search word
	if($i > 0)
		$SearchQueries = sprintf($SearchQueryBase, "%".$SearchArray[$i]."%") . " UNION ALL " . $SearchQueries;
	else
		$SearchQueries = sprintf($SearchQueryBase, "%".$SearchArray[$i]."%");
}

// Insert the search subqueries into the main search query
$SearchQuery = sprintf($SearchQuery, $SearchQueries);
$SearchQuery = mysql_query($SearchQuery) or die("Error executing search, error: ".mysql_error());