Search data based upon keyword or tags entered by USER

[SwapnilD]

I am developing a website for local business classified.

Where Service Provider / Traders will post advertisement of their business / shop etc.

and end user will search for their needs and locate all the adv. based upon their search.

Basically this will be SIMILAR to JUSTDIAL.COM

While posting and adv. I have provided input field to enter KEYWORDS/TAGS to locate their adv. successfully.

e.g. If someone is posting adv. for their Education Institute then they will enter most relevant keywords, which will help their adv. to be found easily by customers.

So, they will enter tags like "Education, Institute, courses, teachers, tutor, Programming, computer courses" etc

AND When user enters either of the keyword their Adv. would be located.

I know this has been already developed by so many sites so far.
I would like to know, what would be the correct way to do it.

Any help would be greatly appreciated.

Thanks and regards,

SD

[hosting charges]

You need to come up with database design first, what all field the table will contain, how will you search and return best match.

[SwapnilD]

Okay, I am using Full Text Search feature for implementing search. But I am having a problem with it.

FOR EXAMPLE...

Their are three rows of data and their TAG column contains below data respectively...

1. Computer
2. Class
3. Computer Class

Whenever user search for "Computer Class" my query returns records in below order

1. COMPUTER
2. Class
3. Computer Class

But, I would like to get most relevant result at the top. So, result would be in below order.

1. Computer Class
2. Computer
3. Class

Please help, how could achieve this?