I have counter $i in my php page , so i want to get the next 15 records right from that $ith row. I am just using the below query bt it is returning empty output. I have plenty of records in db though
SELECT * FROM BOOKS WHERE @ROWNUM > '$i' LIMIT 15