Private Message Help

[Jon7800]

I am trying to write a private message (PM) system for our intranet. I basically have everything working just fine, the only thing I do not know how to do, is to mark a message as being "read" when that message is actually opened.

Does anyone know of a simple way to let the mySQL database know that the message it served has been read and to not show it as 'unread'? I am using an oversized .gif to let users know they have a PM waiting for them....

Thanks!
-Jon

[devinemke]

just create a boolean field in the table that gets flipped after the SELECT query that grabs the message for display to the user.