title: Select and Update in same query
body: <p>Can you select and update in the same query? I'm trying to count views to create a top blog posts by views for my sidebar.</p>
  
  <pre><code>$sql = mysql_query("SELECT * FROM articles WHERE id='$id' LIMIT 1
                      UPDATE pages SET views=views+1 WHERE ID=$id");
  </code></pre>