can mysql work in Windows but not Solaris?
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);
}
--