My client wanted a means of highlighting all messages posted on their site since a user last logged in. (working)
Now they would like to flag if a message hasn't been read by a particular user.
Not sure how best to approach this.
Do I run an insert query to a table, storing userid and messageid whenever the message page is opened ?
Grateful for any ideas.