I know that external resource references cannot be stored in a session variable, and that persistent database connections essentially remove the need to store a database connection resource, but if there were a way to keep result sets alive in some way it would be extremly helpful.
Has been any discussion or work in this direction?
persistent results?
Moderator: General Moderators
Code: Select all
<?php
$rsUsers = mysql_fetch_array($result);
?>print_r($rsUsers) will provide you with a look at the structure and indexing.
it only contains the first recordset. If there are more you need to perform a loop likefor larger sets and simple querries it might by more reasonable to store the SELECT-string and requery the result as needed.
Code: Select all
while($next = mysql_fetch_array($result))
$rsUsersї] = $next;