From: | "Francisco Mosse - (Zivals)" <fmosse(at)zivals(dot)com> |
---|---|
To: | pgsql-php(at)postgresql(dot)org |
Subject: | problem with PHP |
Date: | 2002-11-20 22:26:35 |
Message-ID: | 006001c290e3$e3049720$c334010a@zivals |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave [Hawk-Systems] | 2002-11-21 18:03:10 | Selecting distinct records |
Previous Message | David Busby | 2002-11-19 19:41:34 | Odd looking process tree |