Preserved Topic: Site Search

I'm working on a site search script and don't quite know where to start with making it search each page on the site for whatever is typed into the search area. Can someone point me in the direction of like a tutorial/explanation/anything that could help me?
Thanks
»Cole

»What is life w/o Friends?

What language are you using, and how are the pages setup? PHP and MySQL?

http://www.hotscripts.com/PHP/Scripts_and_Programs/Search_Engines/
http://www.hotscripts.com/Perl/Scripts_and_Programs/Search_Engines/
http://www.hotscripts.com/Perl/Scripts_and_Programs/Searching/

yah Pugz mysql and php, all i've gotten to work so far is a very basic user login thing (i'm working on sessions right now) and a basic news submission/calling script.

thanks max, clicking now =)

»Cole

»What is life w/o Friends?

I've got a very basic search feature on my site, but it only uses "LIKE %$search%" in mysql. This of course only works for matching exact strings (like a word, or a string of characters in a word). How can I make it return matches of any words in the search like a normal search engine?? any tutorials out there that I haven't found yet?

--Lurch--

The poster has demanded we remove all his contributions, less he takes legal action.
We have done so.
Now Tyberius Prime expects him to start complaining that we removed his 'free speech' since this message will replace all of his posts, past and future.
Don't follow his example - seek real life help first.

On a whim, I started to play with LIKE, but I'm lost with a failing SQL query.

If I have my keyword stored in $PageKeywords, how do I use LIKE?

I've tried $sql = "select * from mytable where body like %$PageKeywords%";

If I try searching for, say, "apache", this dies saying the query failed looking for "apache". As syntax is always my downfall.....

I looked at the info on the string comparison functions, but I'm having a hard time making heads or tails.....

Could someone post their query so I can compare?

Nevermind - why can't my server KNOW that I mean '%PageKeywords%' instead of %PageKeywords% ?

The poster has demanded we remove all his contributions, less he takes legal action.
We have done so.
Now Tyberius Prime expects him to start complaining that we removed his 'free speech' since this message will replace all of his posts, past and future.
Don't follow his example - seek real life help first.