This topic is locked
[SOLVED]

 additional where tabs

7/17/2017 7:32:25 AM
PHPRunner General questions
J
jackheitzer@gmail.com author

Hi all,
The additional where tab in the query page is a beautifull enhancement. I have a table with appointments from a year back to next year. Would it be possible to create a tab to show only the "date" from now on. I think this may require a dynamic clause; today's date. How would I go about?
All the best,
Jack

admin 7/17/2017

This can be done, you need to add a WHERE clause that will return today's data.

SELECT * FROM mytable WHERE DATE(posted) = CURDATE()


More info:

https://xlinesoft.com/blog/2014/11/12/datetime-handling-in-web-applications/

J
jackheitzer@gmail.com author 7/18/2017



This can be done, you need to add a WHERE clause that will return today's data.

SELECT * FROM mytable WHERE DATE(posted) = CURDATE()


More info:

https://xlinesoft.com/blog/2014/11/12/datetime-handling-in-web-applications/


Thanks a lot, works like a charm!