This topic is locked

Total records

7/10/2018 10:41:10 PM
PHPRunner General questions
lordcenon author

I like to display somewhere on the screen on displaying, or viewing, editing a number of records; is to show the total records. Is there a function or code snippet that can be inserted somewhere on the screen as onload event either for displaying, viewing, editing, adding records.
Appreciate someone to help.
Thanks.

A
Athlon 7/30/2018

many ways to do this.
You can simply add a field manually in the query designer page to the bottom of the list, show on view only as you can not write to it.. its not a table field.

You can add php code to the valueto do many things but the query has count built into it.
e.g alias name WHAT EVER YOU LIKE (DAYS EXPIRED) , Column value datediff(Pin_Exp, curdate())
or add a field to the table - update it records delete or add...