X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id BC579D1B556 for ; Sun, 26 Oct 2003 15:05:31 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 37868-08 for ; Sun, 26 Oct 2003 11:05:04 -0400 (AST) Received: from mail.gmx.net (pop.gmx.net [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 2F0B0D1B55F for ; Sun, 26 Oct 2003 11:04:59 -0400 (AST) Received: (qmail 21538 invoked by uid 65534); 26 Oct 2003 15:04:55 -0000 Received: from pD9E811BD.dip0.t-ipconnect.de (HELO alpha.centauri) (217.232.17.189) by mail.gmx.net (mp015) with SMTP; 26 Oct 2003 16:04:55 +0100 X-Authenticated: #18432328 Date: Sun, 26 Oct 2003 16:04:49 +0100 From: Matthias Weinhold To: postgresql-php Liste Subject: array fields in the database and their handling with php4 Message-Id: <20031026160449.7a72effa.Matthias.Weinhold@gmx.net> X-Mailer: Sylpheed version 0.9.6claws (GTK+ 1.2.10; i386-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/24 X-Sequence-Number: 2385 Hey, i have a table 'mitarbeiter' in my database, column 'Abteilung' is an array{'Abteilung1, Abteilung2'}, because some people work in more than one section. Now i will print the results from a query like=20 SELECT name, abteilung[1], abteilung[2],FROM mitarbeiter WHERE name =3D D. Benner;=20 to an html-table via php in this form: Name | Benner ------------------- Abteilung 1 | abt_1 ------------------- Abteilung 2 | abt_2 I don't no how to handle the array-field in the database? Any hints? Greetings from cold germany Matthias --=20 Die Asiaten haben den Weltmarkt mit unlauteren Methoden erobert - sie arbeiten w=E4hrend der Arbeitszeit. -- Ephraim Kishon (eigentlich: Ferenc Hoffmann)