Originally Posted by nitinmms

Hi,

Well this is a possible solution:

1. Make a Table say tblForumView with
Following fields:
ID
UserId
lastVieweddate

1. On Login Page, store the User's ID (UserId) in a Session Variable.

2. On the Forum Page in the Page Load Event, check if this userID exists in tblForumView table by saying something like

Help with Code Tags

(Toggle Plain Text)

select count(*) from tblForumView where
userId=Session("UserId")

select count(*) from tblForumView where userId=Session("UserId")

Now, if the above query returns 0 then this userId has not made any views of this page.
So you insert a record for this userId in the table tblforumview.
On the other hand , if count>0 then this UserID has visited eralier, so just update the
field [lastVieweddate] with current date and time.

Storing a [lastVieweddate] will allow you to remind the user as to when he last visited the page.
And also enable you to do some other cool things like for example,

You can display Alll the New Posts which have been posted since his last visit to the forum.

Regards,

Nitin