« Return to Thread: losing MySQL resource

losing MySQL resource

by Stan-51 :: Rate this Message:

Reply to Author | View in Thread

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?




--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

 « Return to Thread: losing MySQL resource