Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9D35747649E for ; Wed, 20 Nov 2002 17:32:11 -0500 (EST) Received: from mail.dosalcubo.com (unknown [200.63.17.2]) by postgresql.org (Postfix) with ESMTP id 602E6476487 for ; Wed, 20 Nov 2002 17:32:10 -0500 (EST) Received: from eduardo ([200.55.4.1] AUTH: LOGIN fmosse@zivals.com) by dosalcubo.com with esmtp (courier 0.40) for ; Wed, 20 Nov 2002 19:32:11 -0300 Message-ID: <006001c290e3$e3049720$c334010a@zivals> From: "Francisco Mosse - (Zivals)" To: pgsql-php@postgresql.org Subject: problem with PHP Date: Wed, 20 Nov 2002 19:26:35 -0300 Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=_natalia-13573-1037831531-0001-2" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/81 X-Sequence-Number: 1663 This is a MIME-formatted message. If you see this text it means that your E-mail software does not support MIME-formatted messages. --=_natalia-13573-1037831531-0001-2 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Mime-Autoconverted: from quoted-printable to 8bit by courier 0.40 Hi!! I found your email addresses in www.postgresql.org I am working in a PHP search engine made with PHP and Postgres... The database has one table called "findmaan" with the following info Column | Type | Modifiers -------------+------------------------+----------- url | character varying(255) | title | character varying(255) | keywords | text | description | text | category | integer | rating | integer | cache | text | and there is another table called "categorias_findmaan" Column | Type | Modifiers -------------+------------------------+----------------------------------------------------------------- idx | integer | not null default nextval('"categorias_findmaan_idx_seq"'::text) descripcion | character varying(255) | Unique keys: categorias_findmaan_idx_key well.. whatīs my problem? : I want to call the name of the category from the idx of the table "categorias_findmaan"... for example, if I add one site in the table "findmaan" whose category is number "5", then the search engine would have to search in table "categorias_findmaan" and find, por example, that that number category is for "Culture web sites"... So.. I canīt understant how do I have to do this... and secondly... how do I add data to the table "categorias_findmaan" if the type is a integer?? I mean, how would I add the number 1=tennis web sites or 2=educational web sites etc... I hope you can help me... ------------------------- Francisco Mosse Coordinador de www.TangoStore.com Zivals S.A. - Tangostore.com Av. Callao 395 C1022AAD Buenos Aires Argentina Tel 54 11 4371 7500 Fax 54 11 4371 7437 --=_natalia-13573-1037831531-0001-2 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Mime-Autoconverted: from quoted-printable to 8bit by courier 0.40
Hi!!
 
I found your email addresses in www.postgresql.org
 
I am working in a PHP search engine made with PHP and Postgres...
The database has one table called "findmaan" with the following info
 
   Column    |          Type          | Modifiers
-------------+------------------------+-----------
 url         | character varying(255) |
 title       | character varying(255) |
 keywords    | text                   |
 description | text                   |
 category    | integer                |
 rating      | integer                |
 cache       | text                   |
 
 
and there is another table called "categorias_findmaan"
 
   Column    |          Type          |                            Modifiers                           
-------------+------------------------+-----------------------------------------------------------------
 idx         | integer                | not null default nextval('"categorias_findmaan_idx_seq"'::text)
 descripcion | character varying(255) |
Unique keys: categorias_findmaan_idx_key
 
well.. whatīs my problem? : I want to call the name of the category from the idx of the table "categorias_findmaan"...
for example, if I add one site in the table "findmaan" whose category is number "5", then the search engine would have to search in table "categorias_findmaan" and find, por example, that that number category is for "Culture web sites"...
 
So.. I canīt understant how do I have to do this...
 
and secondly... how do I add data to the table "categorias_findmaan" if the type is a integer?? I mean, how would I add the number 1=tennis web sites   or 2=educational web sites  etc...
 
I hope you can help me...
 
-------------------------
Francisco Mosse
Coordinador de www.TangoStore.com
Zivals S.A. - Tangostore.com
Av. Callao 395
C1022AAD Buenos Aires
Argentina
Tel 54 11 4371 7500
Fax 54 11 4371 7437
--=_natalia-13573-1037831531-0001-2--