read-unread

What's the most efficient way to remember read/unread status across multiple items?

For example, let's take the format of a forum, where we have multiple users and multiple threads. Say this forum wants to track which users have read which threads and, say, use that information to mark which threads are unread when viewing the thread list. The only solution I can imagine is something that drops a record into the databa...

[PHP] Google Reader Unread Count

I wrote this function to get the unread count of google reader items. function GetUnread($sid) { $url = "http://www.google.com/reader/api/0/unread-count?all=true&output=xml"; $msg = urldecode($msg); $msg = stripslashes($msg); $msg = urlencode($msg); $url = $url . $msg; $purl = parse_url($url); $uri = $pu...

Returning unread records using Linq To SQL

I'm not sure how to ask this question, so I'll start with an example of what I'm doing. Here is my table structure... Documents (Primary key = ID) ID, Title, LatestApprovedRevID Revisions (Primary key = ID) ID, DocumentID, RevisionNum, Body Document_Reads (Primary key = DocumentID, UserName) DocumentID, UserName, RevisionID When a u...