Hello, I am working on a project. And I want to insert the expiry date of the products. So how can I insert the expiry date into mysql using PHP script.
Thanks
Insert Expiry Date into mysql
Moderator: General Moderators
Re: Insert Expiry Date into mysql
you can write the following thing in insert query's values.
DATE_ADD(curdate( ) , INTERVAL ".$exp_years." YEAR )
$exp_years - is number of years.
DATE_ADD(curdate( ) , INTERVAL ".$exp_years." YEAR )
$exp_years - is number of years.
-
jimcarry05
- Forum Newbie
- Posts: 2
- Joined: Tue Dec 29, 2009 5:16 am
Re: Insert Expiry Date into mysql
Thanks..... 