Re: Can of worms re date

From: Date: Mon, 24 Jul 2000 20:16:43 +0000
Subject: Re: Can of worms re date
References: 1 2 3  Groups: php.general 
Request: Send a blank email to php-general+get-7962@lists.php.net to get a copy of this message
If you store a Unix timestamp directly in the database:
    $CutoffDate = time() - (86400 * 7); // Seven days ago.
    mysql_query("DELETE FROM Table WHERE UnixTimestamp < $CutoffDate");
This is what I was looking for! Thanks. Sometimes there's too many ways to skin a cat :) -- www.SpamWhack.com A pre-emptive strike against spam Where's dave? http://www.findu.com/cgi-bin/find.cgi?kc6ete-9 My transistor sings with unintended parasitic the smoke escapes By Jeff Stout

« previous php.general (#7962) next »