note 25533 added to function.ociresult

Note that if you are making multiple table selects, you must specify an alias to each column. This wont work: ---------------------------------------- $qry = "SELECT A.COL_ONE, B.COL_ONE FROM TABLE1 A, TABLE2 B"; $stmt = OCIParse($conn, $qry); while(OCIFetch($stmt)) { $a = OCIResult($stmt, "A.COL_ONE"); ... ---------------------------------------- But this will: ---------------------------------------- $qry = "SELECT A.COL_ONE AS X, B.COL_ONE AS Y FROM TABLE1 A, TABLE2 B"; $stmt = OCIParse($conn, $qry); while(OCIFetch($stmt)) { $a = OCIResult($stmt, "X"); ... ---------------------------------------- Regards, -- http://www.php.net/manual/en/function.ociresult.php http://master.php.net/manage/user-notes.php?action=edit+25533 http://master.php.net/manage/user-notes.php?action=delete+25533 http://master.php.net/manage/user-notes.php?action=reject+25533