olliemaitland Posted October 26, 2003 Share Posted October 26, 2003 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? Quote Link to comment https://forums.phpfreaks.com/topic/1223-fulltext-searching-and-union/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.