[eluser]richzilla[/eluser]
Hi all, ive just implemented a fairly simple post read / unread functionality in an app im working on, but its something ive not done before, and i was wondering wether i was going about it the wrong way or if there was a simpler / more effective way to do it.
Basically at present, i have a table in my database named post_user_flags that contains the fields:
Code:
flag_id
post_id
user_id
when the post is updated a flag is created for any user who has commented on that post. When the user logs in again, a check is made for any entries in the flag table for the users posts. When the user clicks a post that is unread, the flag is deleted.
This is the first time ive done something like this, so i may be going about it the wrong way, any help would be appreciated. Cheers.