Re: works under mysql 5 but not under Oracle 11g1

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





--- 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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux