Best method views by date
<p>I got a little confused about this problem. I am trying to make a views system for my website.</p>

<p>I got a 770 rows of articles in my mySQL database and I'm trying to do a views system to know which article got the most views and when. (Today, 3 Days Ago, This week, This month)</p>

<p>I tried to do something like this in mySQL database:</p>

<p>Table: views</p>

<pre><code>ID  articleID   date
</code></pre>

<p>But then I don't know how to sum it up? and If I will add column 'views' it wont help me because I have to change the dates all time.</p>

<p>amm can someone advice me please?</p>

<p>thanks alot!</p>
