Re: doing SELECTS and keeping the array intact with php

[Sebastian Burg]

julian haffegee schrieb:

> Hi all,
>
> this has been bugging me for some time now.
>
> I want to do a mysql select
> then using php
>
> while ($a_row = mysql_fetch_array($result))
>  {
> do something to get a small portion of the data
> }
>
>
hi julian,

how about using this snip

  $result = mysql_query($sql)or die("fehler:".mysql_error());
  $num = mysql_num_rows($result);

  $erg = array();

  for ($i = 0; $i < $num; $i++) {
   $erg[$i] = array();
   $erg[$i] = mysql_fetch_object($result);
  }

i work with it, and its just fine. put it in a function or a class and 
you wont have to bother about processing the results anymore.

have fun.

greetz seba
---------------
http://www.helft-sebastian.de
http://www.schaudirmaldiean.de
http://www.random-link.com