search functions in php

shahzad11 · 10-30-2007, 01:54 AM

please let me solve my search query problem

when i use Where Clause in php query it returns meabsolute Result

but i wanna use funtion as

my keyword is Free Scripts
and it will return matches for either Free or [COLOR=RED]Scripts[/RED]

thanks in advance to all my helpers

smagik · 11-01-2007, 02:25 AM

try using match in your query, of course to do that you will need to make the database field fulltext

$sql="SELECT * FROM cheats WHERE MATCH(content) AGAINST ('$keyword')";

As I said, match can only be used on fields that are fulltext.

shahzad11 · 11-01-2007, 04:50 AM

will this return results matching one of the word in my keywords?

smagik · 11-01-2007, 03:47 PM

Most definitly, match is designed for this purpose, of course you will need to structure your sql appropriatly

$sql="SELECT * FROM cheats WHERE MATCH(content) AGAINST ('$keyword')
and MATCH(content) AGAINST ('$keyword2')";

to match the field content against the values of the 2 keywords.

There are stop words using match, I would suggest checking the PHP manual for more info.

10-30-2007, 01:54 AM	THREAD STARTER #1 (permalink)
shahzad11 Account Closed Join Date: Nov 2006 Location: Lahore Posts: 297	search functions in php please let me solve my search query problem when i use Where Clause in php query it returns meabsolute Result but i wanna use funtion as my keyword is Free Scripts and it will return matches for either Free or [COLOR=RED]Scripts[/RED] thanks in advance to all my helpers

11-01-2007, 03:47 PM	#4 (permalink)
smagik New Member Join Date: Oct 2007 Posts: 8	Most definitly, match is designed for this purpose, of course you will need to structure your sql appropriatly $sql="SELECT * FROM cheats WHERE MATCH(content) AGAINST ('$keyword') and MATCH(content) AGAINST ('$keyword2')"; to match the field content against the values of the 2 keywords. There are stop words using match, I would suggest checking the PHP manual for more info. __________________ How I had my head chopped off and survived. sitemagik.com Nanaimo.to

11-01-2007, 02:25 AM	#2 (permalink)
smagik New Member Join Date: Oct 2007 Posts: 8	try using match in your query, of course to do that you will need to make the database field fulltext $sql="SELECT * FROM cheats WHERE MATCH(content) AGAINST ('$keyword')"; As I said, match can only be used on fields that are fulltext.

11-01-2007, 04:50 AM	THREAD STARTER #3 (permalink)
shahzad11 Account Closed Join Date: Nov 2006 Location: Lahore Posts: 297	will this return results matching one of the word in my keywords?

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)