Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › Adding to the year in a date from another recordset field and displaying in a date format?

View all replies to this thread

Adding to the year in a date from another recordset field and displaying in a date format?

Thread began 9/28/2017 1:33 am by Nathon Jones Web Design | Last modified 10/16/2017 11:10 am by Nathon Jones Web Design | 1013 views | 2 replies

9/28/2017 1:33 amNathon Jones Web Design

Adding to the year in a date from another recordset field and displaying in a date format?

I have two recordset fields:

Registration Date: <?php echo($rsDOMAINS->getColumnVal("regdate")); ?>
Registration Duration: <?php echo($rsDOMAINS->getColumnVal("regduration")); ?>

The duration field is an integer and is, usually, just 1, indicating 1 year of registration. How do I add this to the reg date field and display in a nice date format?

I use the following date format, but can't work out how to add the regduration to this to display, what is, the expiry date:
<?php echo($rsDOMAINS->getColumnVal("regdate")?date("j F Y",strtotime($rsDOMAINS->getColumnVal("regdate"))):""); ?>

Much appreciated. Thank you.
NJ

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.