Re: [PHP] Deleting mySql records based on dates

2001-02-21 Thread php3
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

Re: [PHP] Deleting mySql records based on dates

2001-02-21 Thread Kevin Cawthorne
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

Re: [PHP] Deleting mySql records based on dates

2001-02-21 Thread Christian Reiniger
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

Re: [PHP] Deleting mySql records based on dates

2001-02-21 Thread Kevin Cawthorne
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 the day limit($day_limit) $limit = bcsub($time,$difference); $sql = mysql_q