Closed Thread Icon

Preserved Topic: Site Search (Page 1 of 1) Pages that link to <a href="http://ozoneasylum.com/backlink?for=21050" title="Pages that link to Preserved Topic: Site Search (Page 1 of 1)" rel="nofollow" >Preserved Topic: Site Search <span class="small">(Page 1 of 1)</span>\

 
ACharmedOne
Bipolar (III) Inmate

From: USA
Insane since: Apr 2001

posted posted 02-25-2002 04:47

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?

Pugzly
Paranoid (IV) Inmate

From: 127.0.0.1
Insane since: Apr 2000

posted posted 02-25-2002 05:16

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

mr.maX
Maniac (V) Mad Scientist

From: Belgrade, Serbia
Insane since: Sep 2000

posted posted 02-25-2002 07:13

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/


ACharmedOne
Bipolar (III) Inmate

From: USA
Insane since: Apr 2001

posted posted 02-26-2002 02:04

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?

Lurch
Paranoid (IV) Inmate

From: Behind the Wheel
Insane since: Jan 2002

posted posted 02-27-2002 09:15

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--

InI
Paranoid (IV) Mad Scientist

From: Somewhere over the rainbow
Insane since: Mar 2001

posted posted 02-27-2002 14:38

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.

Pugzly
Paranoid (IV) Inmate

From: 127.0.0.1
Insane since: Apr 2000

posted posted 02-27-2002 18:00

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?

Pugzly
Paranoid (IV) Inmate

From: 127.0.0.1
Insane since: Apr 2000

posted posted 02-27-2002 18:22

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

InI
Paranoid (IV) Mad Scientist

From: Somewhere over the rainbow
Insane since: Mar 2001

posted posted 02-27-2002 19:04

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.

« BackwardsOnwards »

Show Forum Drop Down Menu