title: PHP SQL Select From Where
body: <p>I am having some difficulty running some SQL code.</p>
  
  <p>What I am trying to do is, find a row that contains the correct username, and then get a value from that correct row.</p>
  
  <p>This is my SQL in the php:</p>
  
  <pre><code>mysql_query("SELECT * FROM users WHERE joined='$username' GET name")
  </code></pre>
  
  <p>As you can see, it looks for a username in users and then once found, it must GET a value from the correct row.</p>
  
  <p>How do I do that?</p>