In this forum and many others you can click on something that says Mark this forum as read. I kinda get how they would do that but what about individual postings. Is there a table that collects this data and then it checks to see if you have been there and if you were there it checks a timestamp of the last post. If anyone could help explain it or show some possible db tables that would be great.
Here is basically what I am trying to do..
I am wanting to create some sorta alert either via a page pop-up or a javascript alert. I would then have a table like:
alerts (table name)
id (this is an auto_increment number)
alert (this is the message that should be shown)
timestamp (this is when it was entered)
agent_id (this is who put the alert in)
The thing is though I will have a page that refreshes itself every 60 seconds. On this page I would have the script that checks to see if there are any new alerts. I would only want to show the alert once to the user. So somehow I have to mark the alert being read by each user.
I hope that someone can help...
Thanks in advance.
