Use session variables in recordset
I'm brand new to the forum and a n00b at PHP and sql - so don't mind me if i'm talking jibberish...
that said -
I'm looking for a way to create a recordset based on session variables.
I have a sql table that contains four feilds: UserID, ItemDescription, ItemAmt and ItemName. When a client logs into my site, I store their userID and other info in session variables.
When they have a balance owing, I want to show a region that displays these feilds, and a "pay now" button. The payment functionality has already been created. When no balance is owing, I want to show a region that reflects that, or simply says something like "you have no current balance" or whatever.
The problem i'm having with the 'show region server behavior' is that when I use 'show if recordset is not empty', it will always show because the UserID feild is never empty. Therefore I need to find a way to only show that region if the other 3 feilds are empty.
I hope i'm making sense here.
Can anyone help out a n00b?
Thanks in advance