I've Just installed UD last week , im trying to create a page where:
user logs in , and the user's details are shown from a database . I have created a login page which works , but how i show the details from a database is proving to be above my me <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

NewBie

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I've Just installed UD last week , im trying to create a page where:
user logs in , and the user's details are shown from a database . I have created a login page which works , but how i show the details from a database is proving to be above my me <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

NewBie
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
I'm new to this myself but I'll give it a go.

You need a detail page to display your users profile/details in the detail page you need to create a record set. I'll assume you know how to create a record set.

the SQL in the record set should be something like this
SELECT *
FROM users (this is the name of the table that stores the info on your users)
WHERE u_login = 'login' (u_login is the field that stores their login name) and (login is the name i used to call the session variable, you should see what i mean later)

then you need to add a variable by clicking on the + button

your variable should be:
Name: login
Default value: 0
Run-time value: session("MM_Username"

Once you've done that click test to see everything works, if it does your nearly there. If not you'll have to keep trying untill you get it to work.

Once you have it working you should see all the fields in your table defined in the record set you just created.

Then it's just a case of dragging them from the record set to the part of your detail page you want the info to appear.

Hope that makes some sort of sense to you…

thanx , i'll give it a go