Re: keyword search help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



thnx for reply sir. actually we are maintaining a cdrom database in
postgresql wherein we have cd rom titlename,author,year etc and keywords
as fields. we will store a set of keywords for each record. i want to know
how to enter those keywords in to database (whether to have comma between
keywords or plain) and code to search for keywords. i.e. if i enter a
keyword then it should search for that keyword in keyword field and
display result. keywords are strings an there will also be some
combinational search. i believe u will see to this and do the needful.
  thanking you
         with rgds
             Arun

On Thu, 31 Jan 2002, Josh Berkus wrote:

> Arun,
> 
> >  i am arun from iisc,bangalore. we are on a database project and are
> >  using
> > postgresql and php. i am finding some problems in keyword search. we
> >  have
> > to store some keywords in a field and when we give some keywords it
> >  should
> > search for the same in that field. how to store in database and how
> >  to
> > access is the problem. pls help me in this matter.
> >   with rgds
> 
> Unfortunately, your question does not have a simple answer, as there
>  are several options depending on waht you're searching, how often, how
>  many users, and what kind of keywords you want to use.  
> 
> What you need is a book on the basics of database design. I do not know
>  of one that has been translated into Indonesian.   You may check out
>  lists of English-language books at:
> http://techdocs.postgresql.org/bookreviews.php
> and
> http://www3.us.postgresql.org/books/index.html
> 
> If English books are no use to you, or exchange rates put them out of
>  your price range, e-mail me back and I will outline some simple
>  methods for keyword searching.
> 
> -Josh Berkus
> 
> ______AGLIO DATABASE SOLUTIONS___________________________
>                                        Josh Berkus
>   Complete information technology      josh@xxxxxxxxxxxx
>    and data management solutions       (415) 565-7293
>   for law firms, small businesses        fax 621-2533
>     and non-profit organizations.      San Francisco
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html
> 



[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux