Re: [PHP] convert query result to array

fetchAll() works if php version is greater than 5.

As Wang suggested, we should write our own function.
its easy... i have done so many times for larger database.

Store earch rows of the resultset in the array (multidimensional ie. 2). and
then work on the array using the loops & conditions

 $query = "select * from tablename";
$result = mysql_query($query);
while($arr = somefunction($result)){
$resultarray[] = $arr;
}

Hope it works!

On 5/13/08, Forcey <[email protected]> wrote:
>
> I guess PDOStatement::fetchAll() should work?
>
> see http://www.php.net/manual/en/pdostatement.fetchall.php for details.
>
>
> - Forcey
>
>
> On Tue, May 13, 2008 at 9:55 AM, Yi Wang <[email protected]> wrote:
> > I think flance's meaning is whether there is a build-in function that
> >  can convert the result set to an array.
> >
> >  The short answer is: do it yourself.
> >
> >
> >
> >  On 5/12/08, Stut <[email protected]> wrote:
> >  > On 12 May 2008, at 15:56, It flance wrote:
> >  >
> >  > > is there any function that can convert the result of  query to an
> >  > associative array?
> >  > >
> >  > > what i want is the following:
> >  > >
> >  > > $query = "select * from tablename";
> >  > > $result = mysql_query($query);
> >  > > $arr = somefunction($result);
> >  > >
> >  > > where $arr should be an assoiative array whose indices have the
> same name
> >  > as the fields names of table tablename.
> >  > >
> >  >
> >  >  http://php.net/mysql_fetch_assoc
> >  >
> >  >  Please please please read the manual: http://php.net/mysql
> >  >
> >  >  -Stut
> >  >
> >  >  --
> >  >  http://stut.net/
> >  >
> >  >
> >  >  --
> >  >  PHP General Mailing List (http://www.php.net/)
> >  >  To unsubscribe, visit: http://www.php.net/unsub.php
> >  >
> >  >
> >
> >
> >  --
> >  Regards,
> >  Wang Yi
> >
> >
> >
> >  --
> >  PHP General Mailing List (http://www.php.net/)
> >  To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>
> --
>
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


-- 
Regards,
Sanjeev
http://www.sanchanworld.com | http://webdirectory.sanchanworld.com - submit
your site