RE: [PHP-DB] oracle: fetch a query result into an array
| From: | Ford, Mike [LSS] | Date: | Wed, 18 Feb 2004 18:34:13 +0000 |
| Subject: | RE: [PHP-DB] oracle: fetch a query result into an array | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-33010@lists.php.net to get a copy of this message | ||
On 18 February 2004 18:22, Torsten Lange contributed these pearls of wisdom:
>
> while(OCIFetch($stmt))
> {
> $column_name = OCIResult($stmt,'COLUMN_NAME');
missing [] here -- should be:
$column_name[] = OCIResult($stmt,'COLUMN_NAME');
> $counter++; }
You might also want to look up ocifetchstatement
(http://www.php.net/ocifetchstatement).
Cheers!
Mike
--
Mike Ford, Electronic Information Services Adviser,
Learning Support Services, Learning & Information Services,
JG125, James Graham Building, Leeds Metropolitan University,
Beckett Park, LEEDS, LS6 3QS, United Kingdom
Email: m.ford@leedsmet.ac.uk
Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211