Database Discussion - help needed

Print Page | Close Window

help needed

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=24251
Printed Date: 29 March 2026 at 9:41pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: help needed

Posted By: codeguru
Subject: help needed
Date Posted: 23 August 2007 at 10:52am

I'm making a forum-like program, and I'm having difficulty designing a particular feature. I want it to store if a user has viewed a particular post or not. I'm not sure exactly how to go about this. What do you think would be the best approach?

-------------
www.coderewind.com
Best Place to hunt for Code

Replies:

Posted By: Mart
Date Posted: 23 August 2007 at 12:16pm

The most efficient way is to store the date/time that the user last visited, and then assume that all posts since that date haven't been viewed, and posts preceding that date have been viewed.
If you don't want to assume that then you would just need a big lookup table.

Posted By: codeguru
Date Posted: 08 September 2007 at 11:56am

Thanks for the advice...

-------------
www.coderewind.com
Best Place to hunt for Code

Posted By: Dilipv
Date Posted: 13 February 2008 at 9:33am

hi there,

i would like to suggest to make use of hitcount server. that will also probably help you to track the record.

Thank you
jitesh
Programmer

-------------
http://www.intelcs.com/ - .Net Consulting