How to make a button to query

xtrapsp

Hey guys,

Just got DT working on my site and I'm pretty new to PHP etc, I know a little. But I was wondering if it was possible to make a button query something specific...

For example lets say I have this information:

Name | Next Service |
John | 06/02/2013 |
Jeff | 12/01/2013 |

Is there a way to make it filter by only showing the people who's next service date is already past the current date?

[code] $query = "SELECT id, customer_name, address, postcode, telephone, mobile, mobiletwo, email, nservice
FROM Customers WHERE DATEDIFF (CURDATE(), nservice) > 0"; [/code] or something

xtrapsp

Ended up making a view table and querying that instead

allan

That's one option - there are always lots. Another would be to use a client-side custom filter and apply a date range to the data. Something similar is done here (although with numbers, rather than dates): http://datatables.net/release-datatables/examples/plug-ins/range_filtering.html

Allan