Jump to content

Archived

This topic is now archived and is closed to further replies.

Cakeman

How to create a search function for my site?

Recommended Posts

Hi

 

I am working on a PHP/MySQL site. I would like to create a search function so people can look for newsposts by submitting keywords.

After a bit of browsing the web, I have found some information about the match() against() functions. I have also read that these functions sometimes deliver \'bizare\' results for smaller databases.

 

Since I can\'t find a decent tutorial on search scripts, I was hoping someone could give some tips on this matter. I thought about a simple query like select * from news where body like %keyword%; However, this allows the user to only use one single keyword. I could solve this by using subqueries: select * from ( select * from news where body like %keyword_1% ) where body like %keyword_2%;

Is this a valid form of a subquery? Will this kind of thing work? Is it efficient?

 

Any help is welcome.

 

Thanks.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.