I want to get date from database, to increment ot decrement it with some days, to show the date and after thath if user confirm it to save it to database.
Can you help me ? Thanks, Rosen "John W. Holmes" <[EMAIL PROTECTED]> wrote in message 002601c29965$7862e950$7c02a8c0@coconut">news:002601c29965$7862e950$7c02a8c0@coconut... > What exactly do you want to do? I'm not a mind reader... > > ---John Holmes... > > > -----Original Message----- > > From: Rosen [mailto:[EMAIL PROTECTED]] > > Sent: Sunday, December 01, 2002 12:54 PM > > To: [EMAIL PROTECTED] > > Subject: Re: [PHP] Date problem > > > > Thanks, > > But I need before to save date in database to do some checks with the > > inc/dec date. > > Cal you help me ? > > > > Thanks, > > Rosen > > > > > > "John W. Holmes" <[EMAIL PROTECTED]> wrote in message > > 002301c29960$21d6a360$7c02a8c0@coconut">news:002301c29960$21d6a360$7c02a8c0@coconut... > > > > I have one problem: > > > > Date field in MySql database with value as "2002-31-12". > > > > I want to increment or decrement this date and to put it again in > > > table. > > > > Can someone help me to increment or decrement date with some days? > > > > > > UPDATE yourtable SET yourcolumn = yourcolumn + INTERVAL 1 DAY WHERE > ... > > > > > > > http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html > > > #Date_and_time_functions > > > > > > ---John Holmes... > > > > > > > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
