[Resolved] [Resolved] resource id

xhat

Any thoughts on this matter would be appreciated. Thanks in advance.

I'm storing the return from mysql_query() into a session variable. The reason for doing this is to build a display page that controls how many items are listed per page. If the user clicks next, then the script runs again. Rather than query the db each time, I'm storing the resource id in the session variable. This works fine on the first run, but on subsequent calls ($_SERVER['PHP_SELF']), PHP complains that I haven't given it a valid resource identifier.

I've confirmed that the session variable works fine in all of the functions on the page for the first call, so I know I'm getting good results.

Weedpacket

You can't store resources in sessions; being links to data being held outside PHP, they're destroyed when the script ends.

Get the results out of the resource and into a PHP array, and session that.

n00854180t

Hey xhat, stick to one thread man. I just replied with somewhat the same thing as Weedpacket in your other thread.

Weedpacket

Originally posted by n00854180t
Hey xhat, stick to one thread man. I just replied with somewhat the same thing as Weedpacket in your other thread.

Especially if your posts are only an hour apart.

xhat

Oops. Sorry. I thought I had Resolved the original post. I meant to close it and provide a better explanation in the second one.

Thanks Weed for the suggestion. I'll give that a shot.