plz tell me how can i run the qoute() function on $srch
i tried to look the function up in mysql doccumentation online but no luck .....
thnx a million
toby ......
From: gerald_clark <[EMAIL PROTECTED]> To: toby z <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: search query crashing mysql ..... :S Date: Mon, 25 Nov 2002 09:17:43 -0600You 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
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus
---------------------------------------------------------------------
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