469,602 Members | 1,726 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,602 developers. It's quick & easy.

add 1 month to date

6
ok guys, another learning experience....I want to add 1 month to a duedate and update. How to include:

(SET duedate = DATE_ADD(duedate, INTERVAL 1 month )

into this:

$sql = "UPDATE payfile SET
amtpaid=?, duedate=?, prevbal=?, latechg=?, secdep=?, damage=?, courtcost=?, nsf=?, hudpay=?, datepaid=?, paidsum=?
WHERE id=?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("dsdddddddsdi", $amtpaid, $duedate, $prevbal, $latechg, $secdep, $damage, $courtcost,
$nsf, $hudpay, $datepaid, $paidsum, $id);
$stmt->execute();
3 Weeks Ago #1
0 6569

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Jim | last post: by
4 posts views Thread by Treetop | last post: by
2 posts views Thread by smcgrath via AccessMonster.com | last post: by
ddtpmyra
9 posts views Thread by ddtpmyra | last post: by
reply views Thread by guiromero | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.