[PHP] Re: php mysql array question

[Pete Morganic]

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

This returns arrays - examples here
http://pear.php.net/manual/en/package.database.db.intro-fetch.php
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



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Re: php mysql array question

[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 [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
 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





-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php