title: delete mysql records of a table after a minute
body: <p>I need help for a simple question ,</p>
  
  <pre><code>$tme = date("Y-m-j H:i:s");
  mysql_query("DELETE FROM PM_TABLE WHERE date &lt;= $time - INTERVAL 60 SECOND");
  </code></pre>
  
  <p>So, It should work and delete all records old as long as long 1 minute.</p>
  
  <p>But it cannot do the operation.</p>
  
  <p>returning value would be like this :\</p>
  
  <pre><code>DELETE FROM PM_TABLE WHERE date &lt;= 2011-07-28 08:49:29 - INTERVAL 60 SECOND
  </code></pre>
  
  <p>table schema :</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `PM_TABLE` (
    `id` int(10) NOT NULL AUTO_INCREMENT,
    `text` varchar(255) COLLATE utf8_bin NOT NULL,
    `date` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) 
  </code></pre>