title: Read or unread message status with php mysql
body: <p>I have a messaging system on my site where users can send messages to one another, I have a mysql database with the following columns in it :</p>
  
  <pre><code> id sentto sentby msgbody created
  </code></pre>
  
  <p>"sentto" is the person to whom msg is sent.
  "sentby" is the msg sender.</p>
  
  <p>I use select statement to display msg on page.</p>
  
  <p>Now i want to add status function Read|unread to my msging system, so that if foo sends a msg to bar ,bar opens his inbox and reads the msg, then foo will see status Read in outbox for the msg.</p>
  
  <p>How is this possible?</p>
  
  <p>Do I need to create 2 more columns "read" "unread" in my chat table?</p>
  
  <p>Any idea?</p>