Is there any reason you can see why the fulltext php/mysql code below works OK on my win2k php4.3.6. mysql 4.1.3 pc but does *not* work when put on a Solaris Server with php5 mysql 4.1.6 ?
That is what happens...I'm suspicious of the accent characters in the code but I am not sure if there's any truth to my suspicion and how I'd even test or fix it(?) Here's the snip I think causes the problem: ... else { if ( $Type_Submit == 'radio_and') { $radio_keyword = preg_replace('/\s+|^/', ' +', $keyword); } elseif ( $Type_Submit == 'radio_phrase'){ $radio_keyword = '"'.$keyword.'"'; } $query = "SELECT page.* FROM `page` LEFT JOIN `keywords` USING (`page_id`) WHERE MATCH (`keywords`.`keyword_txt`) AGAINST ('$radio_keyword' IN BOOLEAN MODE) UNION SELECT page.* FROM `page` WHERE MATCH (`title`, `descrip`) AGAINST ('$radio_keyword' IN BOOLEAN MODE) UNION SELECT page.* FROM `page` LEFT JOIN `url_Pages` USING (`page_id`) WHERE MATCH (`url_Pages`.`page_url`) AGAINST ('$radio_keyword' IN BOOLEAN MODE)"; $result = mysql_query($query); } -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]