making use of a resource id

[robinjohn]

Hi Folks, is it possible to pass a mysql result_id from page to page by storing it in $_REQUEST?

I've pumped out a colourful table and now would like to offer a print version - less the bells and whistles - instead of just running the same query a 2nd time I was wondering whether I could just send and later make use of the resource_id passed back when I originally ran the query.
Something like this:

<A HREF=\"reports.php?event=$_REQUEST[event]&print=true&queryID=$result_id"\"><center>Print Version</center></A>

When I try to access it later all I'm getting is the string
'Resource id' when I try:
echo $_REQUEST['queryID'];

even though I can see something like this in the URL :
....&queryID=Resource%20id%20#7

Any suggestions anyone? It's probably something simple but my head is a little phazed out at the moment 8-(
cheers,
Robin.

[dannys]

Nope, Resources can't be passed around or stored outside of the script - they're purely internal.

There's nothing to stop you storing the array of data from the query though - you might want to take a look at sessions and serialize in the PHP manual.

[robinjohn]

Hey Danny - thanks for letting me know - all the best,
Robin.