First I'll point out that for this intranet I'm using ASP and Access for my DB.
Basically I'm doing pretty well making an Intranet for the place I work. Most of it is in but I have a few niggles that I really need help with. The one that's doing my nut in at the moment is the userlogin. I'm trying to get my head around sessions but I'm not sure if I'm doing it right.

My database has a table called tblStaff. Inside it has an ID, Firstname, Last, e-mail, username, passowrd and their level of access. The login page just uses the above table to check if the user is valid or not. Simple really. I did this all with dreamweaver's server behaviour functions.

The problem is this. For each user I want a personalised page. At the moment they end up at a page called loginmain.asp. The only personalisation they have at the moment is I have a session<MM_Username> so it puts in the name they logged in with. What I want is to be able to access each users data from the database depending on who has logged in. It's nothing complex, just a list of favourites etc on each page, but personalised for each person.

Do I use sessions for this? I'm stuck! Please help.

Kind regards

Jon

you could have a page called user.asp or whatever. or even filter the loginmain.asp so it's tailored to each individual.

you already have a user session, so you could filter the page using that.

i.e login as john > page filtered by username john > displays johns data



regards

Dave Thomas
<b>DMX Zone Manager</b>

I sort of understand but my knowledge is basic. So by using &lt;MM_Username&gt; in a SQL statement I could therefore take data based on that statement? Is that what you're suggesting?

Regards

Jon

By gum, it works! Thanks a lot <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>