title: mySQL Query to list number of comments my site received each day?
body: <p>I run an online magazine and would like a dead-simple way to track 3 metrics:</p>
  
  <ol>
  <li>How many comments are left each day.</li>
  <li>How many links my users submit.</li>
  <li>How many new members I get each day.</li>
  </ol>
  
  <p>This information is all my database, I'm just not sure how to get it out.</p>
  
  <p>I have a "comments" table with about 3500 comments.  Each comment gets a row in the table.  One of the columns in the table is "timestamp."</p>
  
  <p>I'm assuming there's a query that will select this table, sort the rows by timestamp, group them in 24-hour increments and then count the number of rows in each group - telling me how many new comments I received each day.</p>
  
  <p>What would that query look like?  I think I can figure out the other ones if I had the first one working.</p>