mutliple entries in search box

Expand Post »

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

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

hooray

Reputation Points: 11

Solved Threads: 6

Junior Poster in Training

Offline

62 posts
since Jan 2008

Permalink

Jan 26th, 2008

Re: mutliple entries in search box

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.

iamthwee

Featured Poster

Reputation Points: 1536

Solved Threads: 431

Posting Expert

Offline

5,865 posts
since Aug 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Custom Thread Module

Next Thread in PHP Forum Timeline: Confusion with Zoomla Installation

DaniWeb Message

Cancel Changes

User Name
Password