title: how to test date and datetime with mysql
body: <p>My table is using a datetime <code>(YYYY-MM-DD HH:MM:SS)</code> and i need to display today's entries.</p>
  
  <p>my code is only : </p>
  
  <pre><code>SELECT   * 
  FROM     table 
  WHERE    date = '$date' 
  ORDER    BY score DESC
  </code></pre>
  
  <p>with </p>
  
  <pre><code>$date = date("Y-m-d");
  </code></pre>
  
  <p>well, as expected it doesnt work :| you guys have a solution here ?</p>