Good stuff here. http://www.mysql.com/doc/en/Date_and_time_functions.html Check out the SELECT DATE_ADD section. That might be what you're looking for. HTH, Rich > -----Original Message----- > From: David Rice [mailto:haloplayer@hotmail.com] > Sent: Tuesday, March 04, 2003 9:36 AM > To: php-db@lists.php.net > Subject: date functions > > > > > I am looking for a way to take a date stored in a mysql > database... and find > out the date seven days later. > > how would i do this?! > > > cheers, dave > > > > _________________________________________________________________ > Chat online in real time with MSN Messenger http://messenger.msn.co.uk > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php