Jump to content


Photo

How to create a search function for my site?


  • Please log in to reply
No replies to this topic

#1 Cakeman

Cakeman
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 23 November 2003 - 05:47 PM

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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users