Thanks for the quick response! Here is what’s going on - I’m trying to insert the date of today + 11 months into mysql when a user completes a registration form. My insert statement is:
insert into billing (ppl_seq_id, bill_date, due_date, paid_date,billed)
values ($ppl_seq, ADDDate(’$currdate’, INTERVAL 11 MONTHS),null,null,‘N’);
$ppl_seq and $currdate are php variables within my program. If I take out the ADDDate() section of the insert and replace it with my $currdate variable, I don’t get any errors. When I use the ADDDate() mysql function, I get the php parse error. It doesn’t make sense to me. Any suggestions on making the mysql work? That would probably be the best way to handle it if I can get it to work.