Hello.
Can you succesfully execute your query in mysql client program on your
solaris server?
"leegold" <[EMAIL PROTECTED]> wrote:
> 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);
> }
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
