php mysql array question

[Pete Morganic]

I use the PEAR db [url]http://pear.php.net/manual/en/package.database.php[/url]

This returns arrays - examples here
[url]http://pear.php.net/manual/en/package.database.db.intro-fetch.php[/url]

look at the Quick data retreaval down the page

pete


Larry Brown wrote:

> Is there any php function to pull a query into an array? I know there is a
> way to get the first row of the results in an array, but I'm having to loop
> through each row pushing the row onto an array to get the result I'm looking
> for and it seems like a lot of code for something that I would think is used
> a lot.
>
> Larry S. Brown
> Dimension Networks, Inc.
> (727) 723-8388
>
>

[Rob Adams]

It shouldn't take a lot of code to put results into an array:
$query = "select * from table";
$r = mysql_result($query);
while ($row = mysql_fetch_object($r))
$hold[] = $row;
(OR, to index by some id field in the database:)
$hold[$row->id] = $row;
mysql_free_result($r);

Total of 5 lines.

-- Rob




"Larry Brown" <larry.brown@dimensionnetworks.com> wrote in message
news:CBECIONKKLMDDCIKHALJAECJIAAA.larry.brown@dime nsionnetworks.com...

> Is there any php function to pull a query into an array? I know there is

a

> way to get the first row of the results in an array, but I'm having to

loop

> through each row pushing the row onto an array to get the result I'm

looking

> for and it seems like a lot of code for something that I would think is

used

> a lot.
>
> Larry S. Brown
> Dimension Networks, Inc.
> (727) 723-8388
>
>