title: Mysql count columns of users, and group by modified date
body: <p>There are 2 columns that I want data from. Basically I want to see new signups per day. Go easy on me, my first day with mysql (or any DB for that matter)</p>
  
  <p>So far I have this</p>
  
  <pre><code>mysql&gt; select created, count(id) from user group by created;
  +---------------------+-----------+
  | created             | count(id) |
  +---------------------+-----------+
  | 2009-05-27 00:58:56 |         1 | 
  | 2009-05-27 01:27:30 |         1 | 
  | 2009-05-27 02:35:37 |         1 | 
  | 2009-05-27 02:58:56 |         1 | 
  | 2009-05-27 03:36:03 |         1 | 
  | 2009-05-27 03:38:03 |         1 | 
  | 2009-05-27 03:48:16 |         1 | 
  | 2009-05-27 03:51:37 |         1 | 
  </code></pre>
  
  <p></p>
  
  <p>The output I would like is</p>
  
  <pre><code>+---------------------+----------------------+
  | created             | user                 |
  +---------------------+----------------------+
  | 2009-05-27          | 10                   |
  | 2009-05-28          | 13                   | 
  | 2009-05-29          | 19                   | 
  </code></pre>
  
  <p>Any help is appreciated!</p>
  
  <p>Thanks</p>