pass result from mysql_query to $_SESSION?

[mikerh9]

I'm trying to pass result from mysql_query to $_SESSION

$sql = mysql_query("$my_query);
$_SESSION['query_from_script'] = $sql;

THe query has results when I access the $_SESSION['query_from_script'] the result is NULL records.

Is it possible to pass result from mysql_query function to $_SESSION?

[Shrike]

Resources can't be stored in sessions. You would need to extract something from the resource and store that in the session.

Warning
Some types of data can not be serialized thus stored in sessions. It includes resource variables or objects with circular references (i.e. objects which passes a reference to itself to another object).

[mikerh9]

Can array be passed though SESSION?

[bradgrafelman]

Yes. Once you get your result, use [man]mysql_fetch_array[/man] to store the row in array $array, then you can simply use:

$_SESSION['myArray'] = $array;

and can access the array parts like so:

echo $_SESSION['myArray']['foo'];

(outputs the data for column 'foo' in your MySQL row).