pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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 

view thread (2+ messages)  latest in thread

Message-ID: <006001c290e3$e3049720$c334010a@zivals>
Permalink:  ../006001c290e3$e3049720$c334010a@zivals/
Also on:    postgresql.org/message-id/006001c290e3$e3049720$c334010a@zivals

 · 

reply

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