hello. i have a simple internal mail system where users and admin can send messages/mails to each other using mysql as db. when a message is sent this triggers a flag in a field of the db to '1' to signify unread mail. what i am trying to do is when a reply is sent to the sender, the flag of the sender of the original message is set to '0' to signify a read message. seems simple eh! the fields in the db that hold the flag are 'read_frm' and the id is auto-inc and it is that id i ned to update. but what is happening, is that when i update, it updates the message of the new message instead of the original.
I would appreciate some help with what i thought was a simple problem. many thanks
Start Free Trial
