[SOLVED] mysql date insert

[bogdaniel]

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.

[Barand]

$sql = 'INSERT INTO `test`.`res` (`id`, `user_id`,  `data`, `expira`, `time`) VALUES (NULL, \'1\',  NOW(), CURDATE() + INTERVAL 3 DAY, CURTIME());';

[bogdaniel]

$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