I have a SQL query which looks like this :
SELECT code_ver, result FROM mastertest WHERE code_ver NOT LIKE '%DevBld%'
AND date >= DATE_SUB( (CURDATE()) , INTERVAL 90 DAY) ORDER BY date DESC;
This query gives me results from the last 90 days. Now I want to paginate
my results such that each page displays only rows from the last 10 days.
Can someone build a query which I can use with the 'will_paginate' ?