Full text with inner join problem

[[deleted]]

Well i have read the mysql manual and tried finad anything on this forum, but i cant seem to find a proper solution.

i have a mysql query (shown below) that works, it gives the right result.

$results = mysql_query("SELECT *
			FROM br_cards
			INNER JOIN br_cardtype ON (br_cards.card_type = br_cardtype.cardtype_id)
			WHERE MATCH(br_cards.card_name) AGAINST ('$search')
			GROUP BY br_cards.card_id
			LIMIT $page, $limit
			");



while ($row = mysql_fetch_array($results)) {....}

But when adding more fields to the match(), php gives the error: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in....

$results = mysql_query("SELECT *
			FROM br_cards
			INNER JOIN br_cardtype ON (br_cards.card_type = br_cardtype.cardtype_id)
			WHERE MATCH(br_cards.card_name, br_cards.card_extendedname, br_cardtype.cardtype_name, br_cards.card_extendedtype, br_cards.card_terrain, br_cards.card_info, br_cards.card_comment) AGAINST ('$search')
			GROUP BY br_cards.card_id
			LIMIT $page, $limit
			");



while ($row = mysql_fetch_array($results)) {..}

Doesnt matter if i add one or more fields to the match, keep the same warning.

anyone?

thnx
Arjan

[Roger_Ramjet]

Are the additional columns included in the full text index? I'll bet they are not. You need to include all of the columns that you want to search when you create the full text index. It does not matter if you create several indexes for different searches - its only disk space. Most of the overhead with full text search is in the creation of the indexes anyway, but having several with different column inclusion will allow mysql to choose the most efficient index for the particular search.