Postgres Pro
Downloads
Home   >   mailing lists

Thread: FW: Advanced search form

FW: Advanced search form

From
Michelle Konzack
Date:
Hello PGSQL-Gurus,

I have already ask this on pgsql-php and php-db but unfortunatly
gotten no answer.


I have a search form and I like to add advanced search options like

        "this is a search" -XXX Test

which mean,

1)      "this is a search"      must be in this order
2)      -XXX                    Do not find XXX contents
3)      Test                    AND

Does anyone has a PHP/PGSQL code sniplet?

Thanks
Michelle

--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack   Apt. 917                  ICQ #328449886
                   50, rue de Soultz         MSM LinuxMichi
0033/3/88452356    67100 Strasbourg/France   IRC #Debian (irc.icq.com)

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


----- End forwarded message -----
******************************************************************
* Do not Cc: me, because I am on THIS list, if I write here      *
* Keine Cc: am mich, bin auf DIESER Liste wenn ich hier schreibe *
******************************************************************

Hello,


Greetings
Michelle

--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack   Apt. 917                  ICQ #328449886
                   50, rue de Soultz         MSM LinuxMichi
0033/3/88452356    67100 Strasbourg/France   IRC #Debian (irc.icq.com)

Re: FW: Advanced search form

From
Richard Huxton
Date:
Michelle Konzack wrote:
> Hello PGSQL-Gurus,
>
> I have already ask this on pgsql-php and php-db but unfortunatly
> gotten no answer.
>
> I have a search form and I like to add advanced search options like
>
>         "this is a search" -XXX Test
>
> which mean,
>
> 1)      "this is a search"      must be in this order
> 2)      -XXX                    Do not find XXX contents
> 3)      Test                    AND
>
> Does anyone has a PHP/PGSQL code sniplet?

Um - not sure what this has to do with PostgreSQL. You'll probably have
more luck at one of the many PHP developer sites. I shouldn't be
surprised if there was something available in the PEAR repository too.

--
   Richard Huxton
   Archonet Ltd

Re: FW: Advanced search form

From
Michelle Konzack
Date:
Am 2005-12-07 18:16:43, schrieb Richard Huxton:

> Um - not sure what this has to do with PostgreSQL. You'll probably have
> more luck at one of the many PHP developer sites. I shouldn't be
> surprised if there was something available in the PEAR repository too.

I do not get the right QUERY for fulltext search in PGSQL

Greetings
Michelle

--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack   Apt. 917                  ICQ #328449886
                   50, rue de Soultz         MSM LinuxMichi
0033/3/88452356    67100 Strasbourg/France   IRC #Debian (irc.icq.com)

Re: FW: Advanced search form

From
Richard Huxton
Date:
Michelle Konzack wrote:
> Am 2005-12-07 18:16:43, schrieb Richard Huxton:
>
>> Um - not sure what this has to do with PostgreSQL. You'll probably have
>> more luck at one of the many PHP developer sites. I shouldn't be
>> surprised if there was something available in the PEAR repository too.
>
> I do not get the right QUERY for fulltext search in PGSQL

Ah - read up on "tsearch2" which provides text-searching.

--
   Richard Huxton
   Archonet Ltd