Hi, im building a custom forum
I have having trouble deciding what posts are new since the users last visit.
I can do it initially as they have a last visittime.. this is updated every time they visit a page on the site.
so im basically listing the posts that were added after the last visit date... easy enuff.
but once the page is refreshed.. the list is emptied as their visit time will have been updated...
i have though of a way of doing it with a seperated user_viewed table.
for posts.
listing post id's and who has viewed them
but i would like to avoid this as it could cause delays with the database if it was to get large.
VB and PHPbb do this thing very well... i cannot figure out how they do it.
Any ideas suggestions would be much appreciated
Thanks
Rob
forum... checking for new post since last visit.
Moderator: General Moderators
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact: