search query crashing mysql ..... :S

[toby z]

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