Forums

This topic is locked

User Registration question

Posted 15 May 2002 07:01:23
1
has voted
15 May 2002 07:01:23 seth wells posted:
Hey all,
I want to set up a user registration page that will issue a user name and password. However, when users login, I want them to be able to edit their accounts and change information, or see information that is specific to their login.. I have created the database and got to the point where you can register and login but when you login you see the same info no matter what login you use. Can someone help or point me in the right direction. Thanks in advance..
Seth

Replies

Replied 15 May 2002 08:22:37
15 May 2002 08:22:37 Dave Clarke replied:
In the table that holds the information that you want them to be able to see or edit once they have logged in, you need a field with their username, then it is simply a matter of filtering the recordset by the username to get only that users information.

SELECT *
FROM Messages
WHERE Username = 'MMColParam'
ORDER BY MessageDate ASC

if you are using the standard ultradev login then the variable 'MMColParam' should be set to Session("MM_Username"

hope this helps

Dave

Edited by - Davecl on 15 May 2002 08:24:12

Reply to this topic