problem with PHP

This is a MIME-formatted message. If you see this text it means that your
E-mail software does not support MIME-formatted messages.

--=_natalia-13573-1037831531-0001-2
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Mime-Autoconverted: from quoted-printable to 8bit by courier 0.40

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


--=_natalia-13573-1037831531-0001-2
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Mime-Autoconverted: from quoted-printable to 8bit by courier 0.40

Re: problem with PHP

> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--MS_Mac_OE_3120829887_47165785_MIME_Part
Content-type: text/plain; charset="ISO-8859-1"
Content-transfer-encoding: quoted-printable

on 11/20/02 3:26 PM, fmosse@zivals.com purportedly said:

well.. what=B4s 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=B4t 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=3Dtennis web sites
or 2=3Deducational 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"


--MS_Mac_OE_3120829887_47165785_MIME_Part
Content-type: text/html; charset="ISO-8859-1"
Content-transfer-encoding: quoted-printable






on 11/20/02 3:26 PM, fmosse@zivals.com purportedly said:

well.. what=B4s my proble=
m? : I want to call the name of the category from the idx of the table &quo=
t;categorias_findmaan"...

for example, if I add one site in the table "findmaan" whose cate=
gory is number "5", then the search engine would have to search i=
n table "categorias_findmaan" and find, por example, that that nu=
mber category is for "Culture web sites"...



So.. I can=B4t understant how do I have to do this...



and secondly... how do I add data to the table "categorias_findmaan&qu=
ot; if the type is a integer?? I mean, how would I add the number 1=3Dtenni=
s web sites   or 2=3Deducational web sites  etc...

Help...

This is a multi-part message in MIME format.

------=_NextPart_000_000E_01C2A539.0DE62260
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi!

What is wrong? My server has PHP and Postgre
I can=B4t understand hoy do I get this error... look
I start with a value ($quebuscototal) and I should get an array like this (=
"'abc', 'def', 'ghi', 'jkl') ?
but with this code, what I receive is an array where the first element is '=
abc', 'def', 'ghi', 'jkl'
instead of being 'abc' (and the second one, 'def', the third one 'ghi', etc=
..)

$quebuscototal =3D "abc def ghi jkl";
$quebuscototal =3D str_replace(' ',' \', \'',$quebuscototal);
$quebuscototal =3D "'$quebuscototal'";
$quebuscofinal =3D array($quebuscototal);
$quees =3D "$quebuscofinal[1] ";

What is wrong with my code? Thanks!!
Francisco
-------------------------=20
Francisco Mosse=20
Coordinador de www.TangoStore.com
Zivals S.A. - Tangostore.com=20
Av. Callao 395=20
C1022AAD Buenos Aires=20
Argentina=20
Tel 54 11 4371 7500=20
Fax 54 11 4371 7437=20

------=_NextPart_000_000E_01C2A539.0DE62260
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable