Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › I am attempting to show content based on a date in the column. It was working in mySQL, but not now in MySQLi

View all replies to this thread

I am attempting to show content based on a date in the column. It was working in mySQL, but not now in MySQLi

Thread began 3/29/2022 7:35 pm by jo271221 | Last modified 3/30/2022 11:14 am by jo271221 | 241 views | 1 replies

3/30/2022 11:14 amRay BorduinWebAssist

Try:

php:

<?php

if (strtotime($Recordset->getColumnVal("date")) >= strtotime('2020-01-01')) { 

?>

<i class="fa fa-check"></i> Verified

<?php

}

?>

<?php

if (strtotime($Recordset->getColumnVal("date")) < strtotime('2019-12-31')) { 

?>

<i class="fa fa-link"></i> Verify Now

<?php

}

?>

Did this help? Tips are appreciated...

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.