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