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
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 = "
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."\")
Hello All,
Just to add some additional info to our problem. If I do a simple query:
select * from bus_search where match(title,keywords) against('Best Car Deals')
I get nothing! and its there! Is it possible the table is not set up properly??
Or I'm I wishing something here??
Table Info:
CRE
