title: mysql update column then select updated value
body: <p>I have a table like this</p>
  
  <p><strong>tbl_user</strong></p>
  
  <pre><code>id
  user_id
  amount
  </code></pre>
  
  <p>first i want to update a row based on id</p>
  
  <pre><code>$amount = 123; // dyanamic value
  $sql = "UPDATE tbl_user SET amount=amount-'$amount' WHERE id='$id' LIMIT 1 ";
  </code></pre>
  
  <p>now i want to get updated value of amount column i have applied this sql</p>
  
  <pre><code>$sql = "SELECT amount FROM tbl_user  WHERE id='$id'  LIMIT 1 ";
  </code></pre>
  
  <p>my question is can i combine both of above sql or any single query to achieve above task?</p>