Re: Months...Problem..

ok, here DATE_ADD(date,INTERVAL expr type) and here http://www.mysql.com/doc/D/a/Date_and_time_functions.html ------------------------------------------- Yeah, there are more important things in life than money, but they won't go out with you if you don't have any. ----- Original Message ----- From: "Dhaval Desai" <dhaval_adams@yahoo.com> To: <php-general@lists.php.net> Sent: Saturday, January 13, 2001 12:41 PM Subject: [PHP] Months...Problem.. > Hiee! > > > I am having a problem with months...count in a mysql > database.. > > See what I want is > > 1st column will have the current date.. > 2nd column will add 7 to the current date and store > it. > > > This will be for all the 12 months.. > So I want the things to happen automatically..I mean > one script which will check the months and > automatically show output in html page where one > columns as : > Date when entry was made. > > > Second Column > Date when it expires = [Date when entry was made + 7] > > I really got confused..with this one..Coz When I get > current date for the month of January as 30, the > expire date becomes... 37. > LOL [not logical,,perhaps bad programming on my part]; > > > > Help me out please.. > > > Thanx! > Dhaval Desai > > __________________________________________________ > Do You Yahoo!? > Get email at your own domain with Yahoo! Mail. > http://personal.mail.yahoo.com/ > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >