Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1

2008-11-24 Thread Fred Silsbee
--- On Mon, 11/24/08, Chris [EMAIL PROTECTED] wrote: From: Chris [EMAIL PROTECTED] Subject: Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1 To: [EMAIL PROTECTED] Cc: php-db@lists.php.net Date: Monday, November 24, 2008, 6:41 AM Fred Silsbee wrote: while ($newArray

Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1

2008-11-24 Thread Fred Silsbee
--- On Mon, 11/24/08, Chris [EMAIL PROTECTED] wrote: From: Chris [EMAIL PROTECTED] Subject: Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1 To: [EMAIL PROTECTED] Cc: php-db@lists.php.net Date: Monday, November 24, 2008, 6:41 AM Fred Silsbee wrote: while ($newArray

Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1

2008-11-24 Thread Fred Silsbee
--- On Mon, 11/24/08, Chris [EMAIL PROTECTED] wrote: From: Chris [EMAIL PROTECTED] Subject: Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1 To: [EMAIL PROTECTED] Cc: php-db@lists.php.net Date: Monday, November 24, 2008, 6:41 AM Fred Silsbee wrote: while ($newArray

Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1

2008-11-24 Thread Fred Silsbee
--- On Mon, 11/24/08, Fred Silsbee [EMAIL PROTECTED] wrote: From: Fred Silsbee [EMAIL PROTECTED] Subject: Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1 To: Chris [EMAIL PROTECTED] Cc: php-db@lists.php.net Date: Monday, November 24, 2008, 2:44 PM --- On Mon, 11/24/08, Chris

Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1

2008-11-24 Thread Chris
fixed the problem but am not fully sure of the optimum code one should use! I like the association idea but must change the $fields array There is a better way than using count! 67 //get log_book_id table information 68 $user = select * from log_book_id; 69 $result =

Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1

2008-11-24 Thread Fred Silsbee
--- On Mon, 11/24/08, Chris [EMAIL PROTECTED] wrote: From: Chris [EMAIL PROTECTED] Subject: Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1 To: [EMAIL PROTECTED] Cc: php-db@lists.php.net Date: Monday, November 24, 2008, 10:00 PM fixed the problem but am not fully sure

Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1

2008-11-24 Thread Fred Silsbee
--- On Mon, 11/24/08, Fred Silsbee [EMAIL PROTECTED] wrote: From: Fred Silsbee [EMAIL PROTECTED] Subject: Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1 To: Chris [EMAIL PROTECTED] Cc: php-db@lists.php.net Date: Monday, November 24, 2008, 10:31 PM --- On Mon, 11/24/08, Chris

Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1

2008-11-24 Thread Chris
Array ( [LOG_ID] = 405 [FDATE] = 15-JUL-01 [ACTYPE] = C172 [ACID] = N17SJ [NLANDINGS] = 1 [NHOURS] = 1.2 ) So everything is uppercase where you're expecting lower case. while ($newArray = oci_fetch_assoc($result)) { foreach ($fields as $field){ $field = strtoupper($field);

Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1

2008-11-23 Thread Chris
Fred Silsbee wrote: while ($newArray = oci_fetch_assoc($result)) { foreach ($fields as $field){ ${$field} = $newArray[$field];// values not making it into variable }