Re: [PHP] How to delete 3 months old records in my database?
Yeah, just spelling mistake :-) And yes, it should be: $query = "DELETE FROM `__table_name__` WHERE `__date__` <= NOW() - INTERVAL 3 MONTH" Cheers ;-) On Fri, Aug 2, 2013 at 2:35 PM, Simon Schick wrote: > On Fri, Aug 2, 2013 at 2:02 PM, Karl-Arne Gjersøyen > wrote: > > > > 2013/8/2 Dušan Novaković > > > > > $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 > > -- mob: + 46 7 230 230 19 web: http://novakovicdusan.com Please consider the environment before printing this email.
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 wrote: > > 2013/8/2 Dušan Novaković > > > $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
Re: [PHP] How to delete 3 months old records in my database?
2013/8/2 Dušan Novaković > $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
Re: [PHP] How to delete 3 months old records in my database?
Hello,
Try something like:
$oldDate = new DateTime();
$oldDate->sub(new DateInterval('P3M'));
$old_records_to_delete = $oldDate->format('Y-m-d');
Hope this helps,
Si
Sent from my iPhone
On 2 Aug 2013, at 11:58, Karl-Arne Gjersøyen wrote:
> Hello again, folks!
> I wish to delete records in my database that is older than 3 months.
>
> $todays_date = date('Y-m-d');
> $old_records_to_delete = ???
>
> if($old_records_to_delete){
> include(connect.php);
> $sql = "DELETE FROM table WHERE date >= '$old_records_to_delete'";
> mysql_query($sql, $connect_db) or die(mysql_error());
> }
>
> Thank you very much for your help to understand also this question :)
>
> Karl
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] How to delete 3 months old records in my database?
$query = "DELECT FROM `__table_name__` WHERE `__date__` BETWEEN NOW() -
INTERVAL 3 MONTH AND NOW()"
On Fri, Aug 2, 2013 at 12:58 PM, Karl-Arne Gjersøyen wrote:
> Hello again, folks!
> I wish to delete records in my database that is older than 3 months.
>
> $todays_date = date('Y-m-d');
> $old_records_to_delete = ???
>
> if($old_records_to_delete){
> include(connect.php);
> $sql = "DELETE FROM table WHERE date >= '$old_records_to_delete'";
> mysql_query($sql, $connect_db) or die(mysql_error());
> }
>
> Thank you very much for your help to understand also this question :)
>
> Karl
>
--
mob: + 46 7 230 230 19
web: http://novakovicdusan.com
Please consider the environment before printing this email.
