hey there I have problem in running som function in php
I've created simple chat system , I want to delete every message create 1 hour ago or 30 minutes ago
mysql_query("DELETE FROM `chat` WHERE `cht_date` < DATE_SUB(NOW(), INTERVAL 1 MINUTE)");
my "cht_date" type in database is "TIME" .
but the messages didn't delted even once :(
whats wrong with my command ?