title: SELECT AND THEN UPDATE COUNT number mysqli
body: <p>I'm trying to get all the rows from my table products, and then update the product_views too,
  at the same time, </p>
  
  <pre><code>SELECT * FROM `product` WHERE `id` = '26' AND `product_enable`= '1' AND UPDATE `product` SET `product_views` = product_views+1;
  </code></pre>
  
  <p>This code doesn't work, but i think can help for explain what i want to do,... Is there a good way to do this, I think with making this in 1 query should be good for the system right?</p>
  
  <p>So, thanks for you help</p>