fulltext searching and union

[olliemaitland]

I wrote a query which uses the union statement to search two tables...

$q = mysql_query("SELECT sku. * FROM sku, pgr WHERE  MATCH ( pgr.title, pgr.description, pgr.keyword ) AGAINST (  \'".$_POST[\'q\']."\' ) AND sku.pgr=pgr.pgr UNION SELECT sku. *  FROM sku, sgr WHERE  MATCH ( sgr.title, sgr.description, sgr.keyword ) AGAINST (  \'".$_POST[\'q\']."\') AND sku.sgr=sgr.sgr ");

 

then modified it to work on mysql < 4.0.0 to

 

mysql_query("CREATE TABLE temp_union TYPE=HEAP (SELECT sku. * FROM sku, pgr WHERE  MATCH ( pgr.title, pgr.description, pgr.keyword ) AGAINST (  \'".$_POST[\'q\']."\' ) AND sku.pgr=pgr.pgr)");



mysql_query("INSERT INTO temp_union (SELECT sku. *  FROM sku, sgr WHERE  MATCH ( sgr.title, sgr.description, sgr.keyword ) AGAINST (  \'".$_POST[\'q\']."\') AND sku.sgr=sgr.sgr)");



$q = mysql_query("SELECT * FROM temp_union");



mysql_query("DROP TABLE temp_union");

 

however this doesn\'t work on servers which are 3.23.55 when the full text searching was added on 3.23.23

 

can anyone see the problem?