Display user information

[allenio]

I'm looking to display a users information on a page. I have created a page with a dynamic table that will display all records in the DB. I'm looking to have only the information of the user that is signed in to be displayed. How is this done using DreamWeaver CS3?

[Newsgroup_User]

allenio wrote:
> I'm looking to display a users information on a page. I have created a page
> with a dynamic table that will display all records in the DB. I'm looking to
> have only the information of the user that is signed in to be displayed.

Which server technology?

--
David Powers
Adobe Community Expert, Dreamweaver
http://foundationphp.com

[allenio]

I'm using MySQL Version: 5.0.66sp1-enterprise-gpl. PHP Version: 5.2.x

[Newsgroup_User]

allenio wrote:
> I'm using MySQL Version: 5.0.66sp1-enterprise-gpl. PHP Version: 5.2.x

If you're using the Dreamweaver Log In User server behavior, it creates
a session variable called $_SESSION['MM_Username']. Use this to create a
recordset to retrieve the user's information, and display it on the page
in the normal way.

--
David Powers
Adobe Community Expert, Dreamweaver
http://foundationphp.com

[allenio]

>Log In User server behavior, it creates a session variable called $_SESSION['MM_Username'].
>Use this to create a recordset to retrieve the user's information.


Now are you saying to create a new recordset on the page that I have a dynamic table?
When I open the recordset box from the Server Behaviors panel where would I use $_SESSION['MM_Username']?

[Newsgroup_User]

allenio wrote:
> When I open the recordset box from the Server Behaviors panel where would I
> use $_SESSION['MM_Username']?

If you're using the Recordset dialog box in simple mode, set the Filter
options to <name of username column> = Session Variable MM_Username.

--
David Powers
Adobe Community Expert, Dreamweaver
http://foundationphp.com

[allenio]

>If you're using the Recordset dialog box in simple mode, set the Filter
>options to <name of username column> = Session Variable MM_Username.


Thank you. I used this prodedure and it works great. Exactly what I was looking for. I'm shocked that the DreamWeaver help files does not explain the correct use of their own created variables. Anyways thank you David Powers for your help.

[DwFAQ]

Filter recordset where id = Session variable login id