title: Is there a way of combining these 2 MySQL statements?
body: <p>I would like to run a query that adds 1 to the <code>qa_votes</code> field, and then retrieves the resulting value of that field so I can show it on the front end.</p>
  
  <p>So the code draft would be </p>
  
  <pre><code>    $this-&gt;db-&gt;query("
      UPDATE  qa
      SET     qa_votes = qa_votes +1
      WHERE   qa_id = $question_id;
      ");
  </code></pre>
  
  <p>followed by</p>
  
  <pre><code>    $query = $this-&gt;db-&gt;query("
      SELECT  qa_id, qa_votes
      FROM    qa
      WHERE   qa_id = $question_id;
      ");
  </code></pre>
  
  <p>Is there a way of combining these 2 into a single query?</p>