Re: Explain recordset

From: 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 >

« previous php.general (#48550) next »