Got an Sql database, need to create a login page where users use one password stored in database to login and then go to next page which shows info relating to that user. Tried different methods but getting stuck, quite new to Sql queries.

got it all sorted - Thanks

Thought I got it sorted but only half of it. Can bring their username across via session variable but need to display other data relating to that person but geting stuck on how to display the other data relating to the username. Any help will be grateful.

create a recordset and filter it by session variable "MM_UserName" if your doing it with a session.

that'll seperate each persons data for display on their own page.

Regards,
Dave

[DWMX 2004]|[FlashMX 2004 Pro]|[Studio MX 2004]|[SQL]|[Access2000/2002]|[ASP/VBScript]|[XP-Pro]
If you like online gaming, please register @ www.nova-multigaming.com

Don't want to sound stupid, I can show the username on the next page by using the session variable but how do I show other details of that person.
Example: like logging onto dmzone and when you submit your login details you go straight to your profile page.
So your login retrieves data and shows it on the following page.

Thanks
Reg

on the user details page, create a recordset that will obtain all the users details. You will see in the recordset creation window that you have the function to filter the recordset on a value. This value can be a session variable. Just change the session variable to MM_Username and you will get just the info for that user.

Regards
Vince

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting

then in your bindings panel, drag the info on to the page that you want displaying from your database table.

Regards,
Dave

[DWMX 2004]|[FlashMX 2004 Pro]|[Studio MX 2004]|[SQL]|[Access2000/2002]|[ASP/VBScript]|[XP-Pro]
If you like online gaming, please register @ www.nova-multigaming.com

We will finally explain this together Dave....

lol

Regards
Vince

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting

<img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle> <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle> <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

Regards,
Dave

[DWMX 2004]|[FlashMX 2004 Pro]|[Studio MX 2004]|[SQL]|[Access2000/2002]|[ASP/VBScript]|[XP-Pro]
If you like online gaming, please register @ www.nova-multigaming.com

Thank You
Thank You
All working great now.

It's the old saying "if you don't ask you'll never know or learn"

Cheers
Reg