DaniWeb Forum Index > Web Development > PHP

mutliple entries in search box

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jan 2008

Posts: 62

Reputation: hooray is an unknown quantity at this point

Solved Threads: 6

hooray

Offline

Junior Poster in Training

mutliple entries in search box

Jan 25th, 2008

I have a search box on my website, that allows users to look for items that have been posted by other users, I am using this code a the moment, but there is a problem with it

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$category=$_GET['cat'];
$text=$_GET['text'];
$query=mysql_query("
	SELECT *
	FROM event_information
	WHERE category='" . $category . "'
	AND keywords LIKE '%" . $text . "%'
	LIMIT 0, 25");
$category=$_GET['cat'];
$text=$_GET['text'];
$query=mysql_query("
	SELECT *
	FROM event_information
	WHERE category='" . $category . "'
	AND keywords LIKE '%" . $text . "%'
	LIMIT 0, 25");

The problem with this is that say someone was searching for 'chris rock live' and there was an entry it would be fine, bt if they searched for 'live chris rock' then they would not get anything from the database. Is there a way using php that I can take their query and set an array or something to hold the values of each word separatley and include each word in the query

Thanks for looking

•

Join Date: Aug 2005

Posts: 5,266

Reputation: iamthwee is a splendid one to behold

Solved Threads: 377

iamthwee

Offline

Posting Expert

Re: mutliple entries in search box

Jan 26th, 2008

I think to do that, it is going to be more effort than it's worth, but then what do I know. LOL

Maybe
http://dev.mysql.com/doc/refman/5.0/...function_match

Last edited by iamthwee; Jan 26th, 2008 at 4:05 pm.

*Voted best profile in the world*