Urgent: Show content based on what state the user logs in with

Hi guys,

I've painted myself into a bit of a corner and of course have done it on a tight deadline. [:(]

I have created a members table (cms_members) with fields:

username:
password:
email:
state:

And I have create a content table (cms_ipca_content) with fields:

title:
content:
state:

The state fields in both tables are just static lists of the seven states here in Australia.

I have created a login script which works fine to log the user in using the details from cms_members. My question is this.

If the user has a state of "VIC", I want to make it that only content that has a state of "VIC" is presented for the whole session.

I have attached the pages as mentioned - login_success.php is my viewer page for all content and where I presume I need to tell CMS Builder to watch out for the user's state.

If this turns out to be a custom job, that is fine. The matter is a bit urgent.