Jump to content


Photo

fulltext searching and union


  • Please log in to reply
No replies to this topic

#1 olliemaitland

olliemaitland
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 26 October 2003 - 10:38 AM

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?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users