Re: [PHP] How to delete 3 months old records in my database?

On Fri, Aug 2, 2013 at 2:02 PM, Karl-Arne Gjersøyen <[email protected]> wrote:
>
> 2013/8/2 Dušan Novaković <[email protected]>
>
> > $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