Re: Explain recordset
| From: | Plutarck | Date: | Sat, 14 Apr 2001 14:59:55 +0000 |
| Subject: | Re: Explain recordset | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-48550@lists.php.net to get a copy of this message | ||
$result holds a "resource id". When you do anything like mysql_fetch_row it
sends a request to the database. All results, until you "fetch" them, are
kept in MySQL.
If you want to store the results away from the DB you will need to do
something like:
while ($array[] = mysql_fetch_row($result));
That will store all the results into $array...hopefully.
--
Plutarck
Should be working on something...
...but forgot what it was.
"Mike P" <mpeloso@princeton.edu> wrote in message
news:9b9lvb$u57$1@toye.p.sourceforge.net...
> I'm trying to figure out the way recordsets are handled with php and
> mysql.After I issue a query to the Db with $result = mysql_query ($query)
> is the recordset contained in $result or is this just a pointer.I want a
> persistant recordset on the client computer that can be manipulated
without
> going to the server.Is this possable.fetchrow seems to go to the server
> each time or am i wrong?
> Thanks
> Mike P
> mpeloso@princeton.edu
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>