Bug #17141 Updated: Self-References not supported

ID: 17141 Updated by: kalowsky@php.net Reported By: ernst@paradigma.net -Status: Open +Status: Feedback Bug Type: ODBC related Operating System: AIX 4.3.3 PHP Version: 4.1.2 New Comment: Can you please provide a sample schema to reproduce this locally and test this out further? Previous Comments: ------------------------------------------------------------------------ [2002-05-10 09:14:03] ernst@paradigma.net 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. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=17141&edit=1