Tempermental Query?

I have a query that is basically structured like this:

$query1 = "SELECT MATCH () AGAINST ('$search')*4
                        + MATCH () AGAINST ('$search')
                        + MATCH () AGAINST ('$search')
                        AS Relevance
                        FROM items
			WHERE ((MATCH () AGAINST ('$search') OR MATCH () AGAINST ('%$search%') OR MATCH () AGAINST ('$search'))) HAVING Relevance > 25 ORDER BY Relevance DESC";

Code (markup):

I would like to add a new field to the the query so that it can compair my search to one more field but every time i do, my query fails. I include that field in both the "SELECT MATCH" and "WHERE ((MATCH" so that both statements are identical but no go. The field i would like to add exists and resides in the "items" table so i don't see a problem there. Do the fields being queried need to be in a specific order or what? If i try to add or delete anything from this query it fails. Why?

 

When you say it fails, do you mean that no results are returned when you know there should be some? Or do you get an error?

 

Yes, it says "Query Failed" and no results are displayed.

 

did you do a var_dump of the SQL variable or echo $query1? Just display the exact query you will be running, and run it in your sql tool (NaviCat or phpMyAdmin, etc...) - They will give you fuller details of what's F'd up