You did not run the quote() funcion on $arch.
If $arch contains any special characters, it will break your query.
toby z wrote:
hay guyz
im havin a weired problem
i ve this search query
$srch_qry = " select ctnt_inf.* from ctnt_inf ".
" where (match (firstName ) against (\"".$srch."\") ".
" or match (lastName ) against (\"".$srch."\") ".
" or match (summary ) against (\"".$srch."\") ".
" or match (body) against (\"".$srch."\") ".
" or match (title ) against (\"".$srch."\") )";
$srch_qry_hndl = mysql_query ($srch_qry)
or die ('qry failed ! DA tbl must xixt in DA db specifyd bov .... :s');
n im gettin bizzar results .....
i)sometimes it works perfect showin all the results
ii)n some times it missbehavez ..... shows a sorry note for the
strings i KNOW exist in the full text fields im serchin on .....
iii)but most of the times .... it crashes mysql ..... :S
i get thid msg box declaring mysql is gonna shut down
now
1. i ve got win 2K pro, php 4.2.2, mysql 3.23.39 , apache 1.3.24
2. im workin with unicode text n most of the fulltext fields im
searching on are unicode
guyz im all stuck with this query
plz hlp
thnx a mill
toby ......
_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php