heres the situation.
i have a forum table and a members table.
when a post is made it inserts into the forum table. what i want to do is use the username from the members table and use that to get the info from his acount e.g. icq number, email, and anyother thing that is recorded into the members database. how would i go about doing this?
thanx in advance

also how do u do the wo tone thing that this forum uses, where every second replie is on a grey background???

Edited by - fredman1 on 12 Aug 2002 15:05:02

Assuming your members are using the standard UD login behaviour, this creates Session("MM_Username" so all you have to do is filter the members table by this to get that members details.

SELECT *
FROM tbleMembers
WHERE fldUsername = 'Session("MM_Username"'

Check the Macromedia exchange and search for "alternate rows"

dynamic.macromedia.com/bin/MM/exchange/main.jsp?product=ultradev