array fields in the database and their handling with php4 - Mailing list pgsql-php

From Matthias Weinhold
Subject array fields in the database and their handling with php4
Date
Msg-id 20031026160449.7a72effa.Matthias.Weinhold@gmx.net
Whole thread Raw
Responses Re: array fields in the database and their handling with php4
Re: array fields in the database and their handling with php4
List 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)

pgsql-php by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Support for prepared queries
Next
From: Michael Glaesemann
Date:
Subject: Saving result to file for download