🚀 go-pugleaf

Well, you can always do a search for ' ' + word + ' ', but that won't catch
words at the end or beginning of the sentence.  You could write an
explode() function and filter the things through that.
An explode() function takes a string and turns it into an array based on a
delimiter, so given a string suchas "The PowerBuilder for DOS", if you did:

  explode( my_string, " ", my_array )
my_array would wind up with:
  "The", "PowerBuilder", "for", "DOS"
At which point you could search the array for what you want.

 -Matt

jayvee@mayon.cats.edu.ph wrote:

> I would like to ask some hints about SEARCHING...
> This is about Library Management System.
>
> Let's say I have the following in titles in the database:
>
> 1 "The PowerBuilder for DOS"
> 2 "An Introduction to Database and SQL"
> 3 "Advance Newbie"
> 4 "Accelerate into C++ Programming"
> 5 "C++ for Dummies"
>
> When the user search for:
>
> "PowerBuilder"   Displays(1)
> "SQ"             No result
> "SQL"            Displays(2)
> "C++"            Displays(4,5)
>
> (Also I will be filtering : A, An, The, Is, For, blah blah.. To get
>  only the root word)
>
> I don't think I can achive this with that set of data. I'm planing to
> add another table to store the choped version of the title.
>
> Something like this:
>
> 1:PowerBuuilder
> 1:Dos
> 2:Introduction
> 2:Database
> 2:SQL
> 3:Advance
> 3:Newbie
> 4:Accelerate
> 4:C++
> 4:Programming
> 5:C++
> 5:Dummies
>
> With this I can do an IN clause or a series of AND blah.. AND blah...
>
> Is this OK?? Or I'm getting into confusion. Please put me into
> the right path... Or maybe give me some link about this topic.
>
> Thank you very much.
>
> (please respond by e-mail)
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own