Buy Now
Sign in

Show records modified last 24 hours only

morphz , March 06 at 07:34
Answered
M
morphz
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
admin
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
If your main question got answered then please mark the answer using the button!​
​Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!
M
morphz
Works like a charm. Thank you!