> I'm maintaining a session. I successfully connect to a database ($DBConnect
> = mysql_connect()). I save the connection resource in a session variable
> ($_SESSION['connection'] = $DBConnect) ... to use in subsequent queries. It
> remains valid while the user is on the current page.
> print_r($_SESSION['connection']) yields 'Resource id #3', for instance.
> User browses to a new page ... in the same session. $_SESSION['$DBConnect']
> no longer references a valid mysql resource.
> print_r($_SESSION['connection']) yields '0'.
> Other "ordinary" values saved in $_SESSION variables remain valid.
> Is there something special about a mysql resource?
Not about the resource itself, no. PHP closes connections to a Db when a
script ends, unless the connection is persistent, so while the resource
IS saved, the connection to which it refers no longer exists.
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
niel.archer (at) blueyonder.co.uk
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php