title: how to fetch the data according to particular month & year in mysql php
body: <p>Ok, i have a database in which i have all my users registered with their <code>datetime</code> which stores in my MYSQL datetime field as <code>2012-03-31 12:13:42</code> now i want to fetch <code>COUNT</code> of users according to <code>year</code> and <code>month</code>.</p>
  
  <p>As i want to present a chart data for that purpose, i want total customers added in <code>January</code>, in <code>feb</code>, <code>march</code> and so on.... in particular year.</p>
  
  <p>i.e it has to be <code>year specific</code> that in <code>2010</code> <code>Jan</code> lets say <strong>52 Customers</strong> in <code>2010</code> <code>Feb</code> lets say <strong>72 Customers</strong>.</p>
  
  <p><strong>Note</strong>: The query i want to execute is using PHP and Mysql.</p>