dcsimg
www.webdeveloper.com
Results 1 to 3 of 3

Thread: [RESOLVED] Tracking read/unread topics

  1. #1
    Join Date
    Oct 2007
    Location
    Sweden
    Posts
    225

    resolved [RESOLVED] Tracking read/unread topics

    I'm looking for a way to keep track of what topics a user has read or not read in lets say a forum.
    I can think of some ideas, but what is the best way?
    Create a table with a row for each user and create an array of the topics he have read?
    Or is there an easier/faster way?

    Any help is appreciated.

  2. #2
    Join Date
    Nov 2008
    Posts
    2,477
    I would probably create a table with 2 fields, topic_id and user_id, and query that to see if a topic is read.

  3. #3
    Join Date
    Oct 2007
    Location
    Sweden
    Posts
    225
    Would one of those fields have an array?
    Or do you suggest one row for every topic each user has read? (Wouldn't that lead to thousands and thousands of rows?)

    Thanks for the reply.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles