array fields in the database and their handling with php4

From: Matthias Weinhold <Matthias(dot)Weinhold(at)gmx(dot)net>
To: postgresql-php Liste <pgsql-php(at)postgresql(dot)org>
Subject: array fields in the database and their handling with php4
Date: 2003-10-26 15:04:49
Message-ID: 20031026160449.7a72effa.Matthias.Weinhold@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

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

SELECT name, abteilung[1], abteilung[2],FROM mitarbeiter WHERE name =
D. Benner;

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

--
Die Asiaten haben den Weltmarkt mit unlauteren Methoden erobert - sie
arbeiten während der Arbeitszeit.
-- Ephraim Kishon (eigentlich: Ferenc Hoffmann)

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Michael Glaesemann 2003-10-26 15:43:49 Saving result to file for download
Previous Message Christopher Kings-Lynne 2003-10-26 08:20:06 Re: Support for prepared queries