On Fri, Aug 2, 2013 at 2:02 PM, Karl-Arne Gjersøyen <karlarneg@xxxxxxxxx> wrote: > > 2013/8/2 Dušan Novaković <ndusan@xxxxxxxxx> > > > $query = "DELECT FROM `__table_name__` WHERE `__date__` BETWEEN NOW() - > > INTERVAL 3 MONTH AND NOW()" > > > > This delete everything from now and 3months backwards. I want to store 3 > months from now and delete OLDER than 3 months old records. > > Karl Hi, Karl You're right, but restructuring, to get it the way you want, isn't be that hard, is it? :) $query = "DELETE FROM `__table_name__` WHERE `__date__` < NOW() - INTERVAL 3 MONTH" @Dusan, Btw: What is "DELECT"? I assume it should've been "DELETE", right? Bye Simon -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
