Hi!!
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
