expiration date help

From: Date: Wed, 26 Dec 2001 23:51:41 +0000
Subject: expiration date help
Groups: php.db 
Request: Send a blank email to php-db+get-15230@lists.php.net to get a copy of this message
I need to stick a little expiration date into a part of my site but can't seem to get it going properly. Basically, what I need to do is add 2 months to the number of results for a particular member. So if someone has 6 entries in the db, they will all expire in 8 months. I have my $dateadded mysql field is set to DATETIME. Can the calculations be made within the mysql query itself? Is it a job for the DATE_ADD mysql function? I would be displaying the expire date in the admin as well as running it through an CRON script to do an auto-delete. Any suggestions would be awesome! Thanks. __________________ Jason Dulberg Extreme MTB http://extreme.nas.net

« previous php.db (#15230) next »