From: Francisco Mosse - (Zivals) <fmosse@zivals.com>
To: pgsql-php@postgresql.org
Subject: problem with PHP
Date: Wed, 20 Nov 2002 19:26:35 -0300
Message-ID: <006001c290e3$e3049720$c334010a@zivals> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: fmosse@zivals.com
Subject: Re: problem with PHP
In-Reply-To: <006001c290e3$e3049720$c334010a@zivals>
References: <006001c290e3$e3049720$c334010a@zivals>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox