bogdaniel Posted September 17, 2008 Share Posted September 17, 2008 hello i have a small problem with a code can someone help me please ? $sql = 'INSERT INTO `test`.`res` (`id`, `user_id`, `data`, `expira`, `time`) VALUES (NULL, \'1\', NOW(), \'2008-09-20\', CURTIME());'; i want to insert the date from 3 days if today is 09-17-2008 on three days will be 09-20-2008 how can i insert it ? thank you very much for your help. Quote Link to comment https://forums.phpfreaks.com/topic/124680-solved-mysql-date-insert/ Share on other sites More sharing options...
Barand Posted September 17, 2008 Share Posted September 17, 2008 $sql = 'INSERT INTO `test`.`res` (`id`, `user_id`, `data`, `expira`, `time`) VALUES (NULL, \'1\', NOW(), CURDATE() + INTERVAL 3 DAY, CURTIME());'; Quote Link to comment https://forums.phpfreaks.com/topic/124680-solved-mysql-date-insert/#findComment-644023 Share on other sites More sharing options...
bogdaniel Posted September 17, 2008 Author Share Posted September 17, 2008 $sql = 'INSERT INTO `test`.`res` (`id`, `user_id`, `data`, `expira`, `time`) VALUES (NULL, \'1\', NOW(), CURDATE() + INTERVAL 3 DAY, CURTIME());'; thank you very much for you help.. i knew it was something with INTERVAL but didn't know how to use it .. thanks again Quote Link to comment https://forums.phpfreaks.com/topic/124680-solved-mysql-date-insert/#findComment-644024 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.