Forums

Please write a review for the extension you are using on the Joomla extensions directory before posting a new question as we are being spammed by many negative reviews.

Thank you for your support!

Show records modified last 24 hours only

morphz 06 Mar, 2018

Hi all.

I would like to display records that have been modified in the last 24 hours in my connectivity table only.
Stored as mysql "datetime" yyyy-mm-dd hh:mm:ss. Rowname is "modified"

Any ideas?

Kind regards

Max_admin 06 Mar, 2018

Answer

1 Likes

Hi morphz,

in the where conditions of the "read data":

modified/>:<?php echo date('Y-m-d H:i:s', strtotime('-24 hours')); ?>

Best regards

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?

morphz 06 Mar, 2018

Works like a charm. Thank you!

This topic is locked and no more replies can be posted.