why is this not working
Posted: Mon Jun 06, 2011 5:38 pm
I am needing help why this isnt working with the NOW()
the part i put in bold wont work with the NOW() what that is doing is getting the date and then caculating a future date based on the length of the investment package.
if anyone can help me out thanks
its IMPORTANT
Code: Select all
$r=mysql_query("INSERT INTO investments(id,username,user_id,plan_id,plan_name,total_invest,rate,date,end_date,inv_date,reinvest)VALUES
(null,
'".$username."',
" . $id . ",
" . $plans . ",
'". $plan_details['plan_name'] . "',' " . $amount ."','" . $plan_details['percent'] . "',NOW(),
[b]" . "NOW() + INTERVAL " . $pack["invest_period"] . " DAY".",[/b]
NOW(),'$opt')")or die(mysql_error());
if anyone can help me out thanks
its IMPORTANT