title: Inbox Functionality with MYSQL
body: <p>So I am writing a simple inbox private message system. </p>
  
  <p>My table schema is as follows:</p>
  
  <ul>
  <li>messageID</li>
  <li>message</li>
  <li>sender id</li>
  <li>receiver id</li>
  <li>date sent</li>
  <li>read ( 0 = no , 1 = yes)</li>
  </ul>
  
  <p>I am able to show the messages for the user by relating his userID to receiverID. However I also want to show the messages he has sent in the inbox to the user.</p>
  
  <p>For example his inbox should show:</p>
  
  <blockquote>
    <p><strong>Darth Vader</strong> - 3 New messages<br>
    <strong>Luke</strong>  - 0
    new messages (0 because either I read
    all of them OR i sent him the message
    and he has not replied).</p>
  </blockquote>
  
  <p>But what i can only come up with is </p>
  
  <blockquote>
    <p><strong>Darth Vader</strong> - 3 New messages.</p>
  </blockquote>
  
  <p>Can I get any help with how I can accomplish this SQL call?</p>
  
  <p>EDIT: To Clear the Confusion</p>
  
  <p>I am neither Luke or Darth. I have received  3 New messages from darth, and I have sent a message to luke. </p>
  
  <p>EDIT**
  Basically I want to be able to make the inbox like how an SMS app would be, where you can see the sms you just sent in a list of sms's by your friends.</p>