Show records modified last 24 hours only

mo

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
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

mo

morphz 06 Mar, 2018

Works like a charm. Thank you!

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