MySql Resouce Type variable

[rogerclackers]

Is there a way to save a variable of type Resource (in this case a MySql query)?

I simply want to do a search in a database and keep the result as long as I need through different sessions.

[hkucsis]

From the manual

Note: It is currently impossible to register resource variables in a session. For example, you cannot create a connection to a database and store the connection id as a session variable and expect the connection to still be valid the next time the session is restored. PHP functions that return a resource are identified by having a return type of resource in their function definition. A list of functions that return resources are available in the resource types appendix.

If $SESSION (or $HTTP_SESSION_VARS for PHP 4.0.6 or less) is used, assign values to $SESSION. For example: $_SESSION['var'] = 'ABC';

[rogerclackers]

I notice that in the manual that I can't save a Resource variable in a database, but I was wondering if it is possible to store it temporary somewhere in file or anywhere.

Obviously not.

Thanks.