--- On Mon, 11/24/08, Chris <dmagick@xxxxxxxxx> wrote: > From: Chris <dmagick@xxxxxxxxx> > Subject: Re: works under mysql 5 but not under Oracle 11g1 > To: fredsilsbee@xxxxxxxxx > Cc: php-db@xxxxxxxxxxxxx > Date: Monday, November 24, 2008, 6:41 AM > Fred Silsbee wrote: > > > while ($newArray = oci_fetch_assoc($result)) { > > foreach ($fields as $field){ > ${$field} = $newArray[$field]; // values not > making it into variable > > } > > > print_r($newArray); > > what is here? > > Oracle uppercases all fields, tablenames by default (per > sql spec). > > -- Postgresql & php tutorials > http://www.designmagick.com/ I am new to PHP and I was wondering if an array can contain dissimilar types while ($newArray = oci_fetch_assoc($result)) { surely a DB row might contain : create table log_book_id ( log_id number primary key, fdate date, actype varchar2(16), acid varchar(16), nlandings number, nhours number); insert into log_book_id values (logid.nextval, TO_DATE('08/12/1973','MM/dd/YYYY'),'C150','N5787G',1,1.8); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php