Mysql procedure to modify limit and offset
Just a thought in my mind but would it not be possible to createa function in MySQL that can modify the LIMIT within a query The clause would be a simple calculation function that would work out the offset depending on the pageno * perpage Example SELECT * FROM items PAGE(4,20) this would be the same as SELECT * FROM items LIMIT 10...