I just play around with lsql as a news-blog without any detailed pages.
I make a new page every 25 links.
Now i want to have the title of the first link as the title of the page.
So i should have something like:
call a new global and pass the number of page (maybe there is a global for as i remember)
calculate: number of page = 1, then x = (nop -1) * 25 + 1 = 1
number of page = 2, then x = 26
number of page = 3, then x = 51
Now fetch the title of the 51th link and set it to html title.
SELECT * FROM Links ORDER BY some LIMIT 1 OFFSET 50;
I make a new page every 25 links.
Now i want to have the title of the first link as the title of the page.
So i should have something like:
call a new global and pass the number of page (maybe there is a global for as i remember)
calculate: number of page = 1, then x = (nop -1) * 25 + 1 = 1
number of page = 2, then x = 26
number of page = 3, then x = 51
Now fetch the title of the 51th link and set it to html title.
SELECT * FROM Links ORDER BY some LIMIT 1 OFFSET 50;