re: Re: search query crashing mysql ..... :S

2002-11-26 Thread Victoria Reznichenko
toby, Tuesday, November 26, 2002, 10:55:38 AM, you wrote: tz> plz tell me how can i run the qoute() function on $srch tz> i tried to look the function up in mysql doccumentation online but no luck tz> . Here is described how QUOTE() function works: http://www.mysql.com/doc/en/String_fu

Re: search query crashing mysql ..... :S

2002-11-26 Thread toby z
Subject: Re: search query crashing mysql . :S Date: Mon, 25 Nov 2002 09:17:43 -0600 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 = "

Re: search query crashing mysql ..... :S

2002-11-25 Thread gerald_clark
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."\")