I was trying to view a self-referenced Table (parent_id is the id of another member); with OBDC towards DB2 (on AIX 4.3.3) PHP does not set the array right; I dont get the parents name but the childs name twice.

Code
====
$conn=odbc_connect("db", "user", "pass");
$stmt="select a.bm_id, a.bm_bezeichnung, b.bm_bezeichnung as parent_bm_bezeichnung from schema.table a, schema.table b where b.bm_id=a.bes_bm_id";
$res=odbc_exec($conn,$stmt);
print odbc_result_all($res);

ODBC Result
===========
BM_ID BM_BEZEICHNUNG PARENT_BM_BEZEICHNUNG 
5 Tonband  Tonband  
6 Handy  Handy  
2

(the 2 is new, seems to be the "2 records selected" rest)

DB2 Result
==========
BM_ID  BM_BEZEICHNUNG       PARENT_BM_BEZEICHNUNG
------ -------------------- ---------------------
     5 Tonband              Telefonisch
     6 Handy                Telefonisch

  2 record(s) selected.