title: Get the number of posts x category from date y
body: <p>I'm creating a dictionary system which kinda works like urban dictionary. i want to get the number of posts of today/yesterday/random. the table structure i'm using right now is like this:</p>
  
  <p>words:</p>
  
  <pre><code>|id|name  |lastupdate(unixstyle)
  |1 |apple |today
  |2 |potato|yesterday
  |3 |pear  |today
  |4 |php   |three days ago
  </code></pre>
  
  <p>definitions:</p>
  
  <pre><code>|id|wordid|date
  |1 |1     |three days ago
  |1 |4     |three days ago
  |1 |1     |three days ago
  |1 |2     |yesterday
  |1 |2     |yesterday
  |1 |1     |yesterday
  |1 |4     |today
  |1 |3     |today
  |1 |1     |today
  </code></pre>
  
  <p>with this table structure i can easily get the number of definitions of today. but what i actually wanna do is to be able to get the posts of anyday i want.</p>
  
  <p>the result i want kinda looks like this:</p>
  
  <pre><code>today's words:
  apple(1 definition)
  pear(3 definitions)
  php(4 definitions)
  </code></pre>
  
  <p>it's my first post on stackoverflow :) i hope i clearly said what i wanna do. i'll be glad if someone could help me with this problem.</p>
  
  <p>thanks in advance :)</p>
  
  <hr>
  
  <p><strong>PROBLEM SOLVED</strong></p>
  
  <p>I found the solution after hours of research(silly me). All i had to do is use INNER JOIN to get what i want. The solution is like this:</p>
  
  <pre><code>SELECT words.name
  FROM words
  INNER JOIN definitions ON words.id = definitions.wordid
  WHERE date &gt; 1354053600
  </code></pre>
  
  <p>The date i used is an example of course. All you need to do is change it using the unixdate you want :)</p>