ok there is a lot of stuff that is going to be asked so any help would be great!

1) I have made a basic forum, i have stuffed a session variable with the users details in it. With this I instert the username into the post form. is there away to use the username that was posted to find info from another table in a database and display that aswell. i think i am confussing you all so i will give an example...

john logs in
john posts a message in the forum
johns username is displayed along with his post.

but what i want to be displayed is
johns username, access level, number of posts etc...

now i'm aware that i could put all these in with using the session variable but i want to save space in my database.

2) The UdForum displays
"New posts since last logon.
Active topic. ( 20 replies or more. )
Locked Topic"

how would i go about setting all these things up - i know how to set this up "Active topic. ( 20 replies or more. )" but i would like to know the others

3) I would like to display what members are currently signed in, how would i go about doing this?


if i'm not making myself clear then please ask me for more details

thanx,
fredman





Edited by - fredman1 on 26 Jul 2002 17:53:43

please guys, i have looked everywhere for tutorials but to no avail!!! PLEASE help pleeeeease

I'd help if i could.
I suggest downloading a forum, and examining the code within, most of them are heavily commented.

A good free ASP forum can be found at www.webwizguide.co.uk

"Get the kettle on, time for a brew"

1. Make relationship between those two tables (post and users) and create view (query in MS Access) that will combine data from them. Since you have in both tables, they will be related fields. Once you have view (query), display it on a page in a same way as you would display data from some table.
2. Create view (query), filter data depending on what you want to accomplish and sum values.
3. You can acomplish this using global.asa file. Search a little on google (keywords: global.asa, active users) and you'll find lots of tutorials.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
1) Is there away to use the username that was posted to find info from another table in a database and display that aswell.
2) I know how to set this up "Active topic. ( 20 replies or more. )" but i would like to know the others

3) I would like to display what members are currently signed in, how would i go about doing this?


if i'm not making myself clear then please ask me for more details

thanx,
fredman





Edited by - fredman1 on 26 Jul 2002 17:53:43
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic
www.farcic.com
TalkZone Manager

Edited by - vfarcic on 31 Jul 2002 17:27:06