title: How do I select one row from a MySQL table?
body: <p>If I know the query only returns one row, and more specefically, in this case one value, </p>
  
  <pre><code>$full_name = database::query("SELECT concat (fname, ' ', lname) from cr WHERE email='$email'");
  </code></pre>
  
  <p>how do I get that value into a single variable.  Database::query returns the value form mysql_query.  The query above insert "Resource ID 4" in to mysql table.</p>
  
  <p><img src="https://i.stack.imgur.com/SVHMU.png" alt="Credentials(cr)"></p>
  
  <p><img src="https://i.stack.imgur.com/eWgrr.jpg" alt="Tweets(tw)"></p>