Hi-- In times past (in fact, within the same web site) I use OCIFetchStatement($qry, $arrayResults); Later I use the following code to access a value within the array:
$arrayResults['FIELD'][0] This works great! BUT, now I have a slightly more complicated query. When I call OCIFetchStatement(...) I get the right number of rows reported, but the technique used above no longer accesses the information. I get a "Not a T_VARIABLE or T_NUM...blah blahh.. " error. Here is the query--all the columns are aliased. ---------------------------------------------------------------------------- -------------------------------------------------------------- $qryStr = "select ig.value as IMG, im.value as MSG, ut.name as F_NAME, ut.addr1 as F_ADDR1, ut.addr2 as F_ADDR2, ut.city as F_CITY, ut.state as F_STATE, ut.zip as F_ZIP, a.fname as T_FNAME, a.lname as T_LNAME, a.prefix as T_PREFIX, a.suffix as T_SUFFIX, a.addr1 as T_ADDR1, a.addr1 as T_ADDR2, a.city as T_CITY, a.state as T_STATE, a.zip as T_ZIP FROM productout po, item ig, item im, usertbl ut, address a WHERE ig.userid = ut.userid and po.addressid = a.addressid and ig.type = 'IMG' and ig.itemid in(select itemid from product where productid = po.productid) and im.type = 'MSG' and im.itemid in(select itemid from product where productid = po.productid) union select ig.value as IMG, im.value as MSG, ut.name as F_NAME, ut.addr1 as F_ADDR1, ut.addr2 as F_ADDR2, ut.city as F_CITY, ut.state as F_STATE, ut.zip as F_ZIP, a.fname as T_FNAME, a.lname as T_LNAME, a.prefix as T_PREFIX, a.suffix as T_SUFFIX, a.addr1 as T_ADDR1, a.addr1 as T_ADDR2, a.city as T_CITY, a.state as T_STATE, a.zip as T_ZIP FROM productout po, item ig, item im, usertbl ut, address a, addr_groups ag WHERE ig.userid = ut.userid and po.addrgrpid = ag.addrgrpid and a.addressid = ag.addressid and ig.type = 'IMG' and ig.itemid in(select itemid from product where productid = po.productid) and im.type = 'MSG' and im.itemid in(select itemid from product where productid = po.productid)"; ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- -------------------- Why won't the following work: for($i = 0; $i < $numRows; $i++) { echo "$arrayResults['IMG'][$i]<br>"; } Neither will this: $arrayResults[0][0]; Here is some info: list($key, $value) = each($arrayResults); echo "$key"; ==> IMG echo "$value"; ==> Array list($key2, $value2) = each($value); echo "$key2"; ==> 0 echo "$value2"; ==> path/image1.jpg This tells me that this: $arrayResults['IMG'][0] should return: path/image1.jpg It doesn't. PHP returns all column names as invalid keys. Yet it returns all the column names as keys when I ask it too. What am I missing? Thanks RDB -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php