Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Need som help with php date calculations from mysql database

Need som help with php date calculations from mysql database

Thread began 3/01/2012 9:33 am by Rune Brynestad | Last modified 3/02/2012 10:30 am by Rune Brynestad | 2017 views | 6 replies

3/02/2012 5:10 amRune Brynestad

Thanks. Your suggestion works perfect.

I have another case. If the arrival date is more than 2 weeks old, the user should be redirected to another page, so I believe I have to use an if statement like this:

<?php if (date("d.m.Y H:i:s") > (date('d.m.Y H:i:s', strtotime($row_rsArrivals['arrivaldate']."+ 2 week")))) { ?>
<?php
header ( 'Location: redigering_stengt.php' ) ;
?>
<?php } ?>

But the user is not redirected, no syntax error in my if statement.

I'm attaching a file where I have put together an example. You can also see it on live URL here:

Untitled-2.php

Thanks

Regards
Rune

Attached Files

Untitled-2.zip

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.