pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedproblem with PHP
2+ messages / 2 participants
[nested] [flat]
* problem with PHP
@ 2002-11-20 22:26 Francisco Mosse - (Zivals) <fmosse@zivals.com>
2002-11-23 00:11 ` Re: problem with PHP Keary Suska <hierophant@pcisys.net>
0 siblings, 1 reply; 2+ messages in thread
From: Francisco Mosse - (Zivals) @ 2002-11-20 22:26 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: problem with PHP
2002-11-20 22:26 problem with PHP Francisco Mosse - (Zivals) <fmosse@zivals.com>
@ 2002-11-23 00:11 ` Keary Suska <hierophant@pcisys.net>
0 siblings, 0 replies; 2+ messages in thread
From: Keary Suska @ 2002-11-23 00:11 UTC (permalink / raw)
To: pgsql-php
on 11/20/02 3:26 PM, fmosse@zivals.com purportedly said:
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...
What you seem to be asking here are basic SQL concepts. The list can't
really teach you SQL. There are many good books that can teach you SQL, or
you can try the tutorial at www.postgres.org.
Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-11-23 00:11 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-11-20 22:26 problem with PHP Francisco Mosse - (Zivals) <fmosse@zivals.com>
2002-11-23 00:11 ` Keary Suska <hierophant@pcisys.net>
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