Hi,

I am currently developing a database system which allows users to enter insect records. I have created a login option using the user login server behaviour which works fine, but what I would like it to do is when a user logs in it takes them to a page which displays only their entered records from the database. Sort of a personal storgae space for their insect records.

What I'm struggling with is how to pass a url parameter as well. The login server behaviour users 'post' in the form. Could someone please help with this as I'm completely stuck.

I'm very much a novice.

Thanks

Simon

Hi,

Consider this and see if its what youre after...

From the login page, the user goes to a menu/welcome page, from here there is text form which the username (session variable) appears in, next to this is a button- pressing this button passes the info to a detail page - which on this detail page lists all the records/entries specific to that user.

I think this is what youre after... So what I mean is you have to setup a search page first (menu page) which passes parameters to a detail page and will filter only for that user.

Thanks, that is what I'm after. So what you are saying is that I need a page between my records display page to pass the url parameter.

Thanks

Simon

Hi,

Yep, exactly! When I was setting a similar thing up, I read that it isnt possible to display filtered records on a page directly from a login, it can only be done first by having a search facility that passes to a detail page.

Sorry, I've just the reply again and yes that is exactly what I'm trying to do, but how to I pass the session vairable to a form text field in order to pass the value to a reults page list the records relevant to the user. Could you please give me an example of the php code extra. I really rely on dreamweaver generating the code for me.

Thanks

Simon

Hi,

Actually you can have that table on the first page of your site sorry!

You first have to set up a log in screen so that a session variable can be used. Then just filter your recordset by that session variable, and the entries should come up on the first page on your site as you wanted for the particular user.