title: How to solve date automatic update in database?
body: <p>I am using now() function for article published date and also article views counter.I am using following query</p>
  
  <pre><code>mysqli_query($connect,"UPDATE posts SET article_views = article_views+1 where id = '$post_id'");
  </code></pre>
  
  <p>problem is that the date is also updated by this query. so how i can solve this problem.</p>