login redirect & session variables

Hi, I am trying to build a site in dreamweaver cs3 where, on login, the user is directed to a specific page which contain information which is only for their eyes. I am ok with the forms etc but it is the session variable and the sql that is throwing me at the moment. e.g. on amazon you would have "my account" My site is for holiday accomodation and the tables I am using are owner details where the owner inputs personal details and cottage details which hold all the details for the cottage. In owner details tbl the id is ownerid and this is also a foreign id in the cottage table. What I need to do is that when the owner logs in they go to a master/detail set that only shows their cottages. Any help would be gratefully accepted as this one is blocking me.ta.