Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-php by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group