problem with PHP

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

Responses

Browse pgsql-php by date

  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