Michael,
Don't store resources in your session. They die when the page is
finished rendering. Variables you can store in your session. Even
objects can be stored in your session. But do not store resources.
I would suggest a couple of things.
1: Use ADOdb instead of just raw my_sql statements.
I have a fairly common problem that I have not been able to find the
solution for in the documentation and FAQs. I have to access a MSSQL box
from a LAMP box using PHP. That part works fine (thank you freetds.org). I
need to display results from user queries 10 at a time with the basic NEXT
and BAC
