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?