try using the date_* functions in mysql
its somewhere in the manual reference section, date and time functions.
-------------------------------------------
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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
