pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
problem 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