page turn

[boionfire81]

I found this code

https://codepen.io/hackfin/pen/fyKHx

I'd like to implement it instead of a pagination. Is that possible to limit results to 10 results per "wrapper"

[TheMasterGeneral]

Yeah. I'd assume it would be running a "while" loop while fetching rows from your database, limiting to 10 per attempt.

Do I have the code for it, nope. lol. :D

[Dayo]

here is an example

select * from test order by ID asc LIMIT 0, 10; -- gets rows 0-10
select * from test order by ID asc LIMIT 10, 10; -- gets rows 11-20
select * from test order by ID asc LIMIT 20, 10; -- gets rows 21-30
select * from test order by ID asc LIMIT 30, 10; -- gets rows 31-40

$page = (int) $_GET["page"];
$sql = "select * from test order by ID asc LIMIT ".($page * 10).", 10";

[Sim]

I would use jQuery for it. Unlimited =}