Addressed to: "Kevin Cawthorne" <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]>
** Reply to note from "Kevin Cawthorne" <[EMAIL PROTECTED]> Wed, 21 Feb 2001
13:19:54 -
>
> The reason I used that route was to show the logic.
>
> Yes its long- some people may not want a mysql reliant way
1 PM
Subject: Re: [PHP] Deleting mySql records based on dates
> On Wednesday 21 February 2001 14:00, Kevin Cawthorne wrote:
>
> > Try something like:
> >
> > $time = time(); // unix time now
> > $day_limit = 28; // how many days to allow
> >
> > $day
On Wednesday 21 February 2001 14:00, Kevin Cawthorne wrote:
> Try something like:
>
> $time = time(); // unix time now
> $day_limit = 28; // how many days to allow
>
> $day = 86400; // how many seconds in 24 hours(1 day)
> $difference = bcmul($day_limit,$day); // multiply the seconds($day) by
> t
= mysql_query("delete from table where date<='".$limit."'", $dbh);
Kevin Cawthorne
- Original Message -
From: "Thomas Edison Jr." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 21, 2001 12:53 PM
Subject: [PHP] Deleting m
How do I delete records from my mySql database which
are three weeks old?? I will be declaring a date field
for the records but what coding should I do in order
to check if the records are three weeks old and then
erase them so that my data is up to date??
Regards,
T. Edison jr.
=
Rahul S. J
5 matches
Mail list logo
