From fmosse@zivals.com Wed Nov 20 22:32:11 2002 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-- From hierophant@pcisys.net Sat Nov 23 00:11:29 2002 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B1F5C475CA6 for ; Fri, 22 Nov 2002 19:11:29 -0500 (EST) Received: from krusty.pcisys.net (krusty.pcisys.net [216.229.32.178]) by postgresql.org (Postfix) with ESMTP id 06502475B8F for ; Fri, 22 Nov 2002 19:11:29 -0500 (EST) Received: from [208.202.106.215] (moe1.meg106-215.cos.pcisys.net [208.202.106.215]) by krusty.pcisys.net (8.12.5/8.12.5) with ESMTP id gAN0BQG2024991 for ; Fri, 22 Nov 2002 17:11:30 -0700 (MST) User-Agent: Microsoft-Outlook-Express-Macintosh-Edition/5.0.4 Date: Fri, 22 Nov 2002 17:11:27 -0700 Subject: Re: problem with PHP From: Keary Suska To: Postgres-PHP Message-ID: In-Reply-To: <006001c290e3$e3049720$c334010a@zivals> Mime-version: 1.0 Content-type: multipart/alternative; boundary="MS_Mac_OE_3120829887_47165785_MIME_Part" X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/87 X-Sequence-Number: 1669 > This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --MS_Mac_OE_3120829887_47165785_MIME_Part Content-type: text/plain; charset="ISO-8859-1" Content-transfer-encoding: quoted-printable on 11/20/02 3:26 PM, fmosse@zivals.com purportedly said: well.. what=B4s 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=B4t 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=3Dtennis web sites or 2=3Deducational web sites etc... What you seem to be asking here are basic SQL concepts. The list can't really teach you SQL. There are many good books that can teach you SQL, or you can try the tutorial at www.postgres.org. Keary Suska Esoteritech, Inc. "Leveraging Open Source for a better Internet" --MS_Mac_OE_3120829887_47165785_MIME_Part Content-type: text/html; charset="ISO-8859-1" Content-transfer-encoding: quoted-printable Re: [PHP] problem with PHP on 11/20/02 3:26 PM, fmosse@zivals.com purportedly said:

well.. what=B4s my proble= m? : I want to call the name of the category from the idx of the table &quo= t;categorias_findmaan"...
for example, if I add one site in the table "findmaan" whose cate= gory is number "5", then the search engine would have to search i= n table "categorias_findmaan" and find, por example, that that nu= mber category is for "Culture web sites"...

So.. I can=B4t understant how do I have to do this...

and secondly... how do I add data to the table "categorias_findmaan&qu= ot; if the type is a integer?? I mean, how would I add the number 1=3Dtenni= s web sites   or 2=3Deducational web sites  etc...

What you seem to be asking here are basi= c SQL concepts. The list can't really teach you SQL. There are many good bo= oks that can teach you SQL, or you can try the tutorial at www.postgres.org= .

Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"
--MS_Mac_OE_3120829887_47165785_MIME_Part--