Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

Fields from the first post at the nth page of a category

Quote Reply
Fields from the first post at the nth page of a category
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;
Subject Author Views Date
Thread Fields from the first post at the nth page of a category Robert 12793 Jul 18, 2016, 11:42 AM
Thread Re: [Robert] Fields from the first post at the nth page of a category
Andy 12503 Jul 19, 2016, 4:54 AM
Thread Re: [Andy] Fields from the first post at the nth page of a category
Robert 12493 Jul 19, 2016, 11:04 AM
Post Re: [Robert] Fields from the first post at the nth page of a category
Robert 12483 Jul 19, 2016, 11:05 AM
Thread Re: [Robert] Fields from the first post at the nth page of a category
Andy 12472 Jul 19, 2016, 10:49 PM
Thread Re: [Andy] Fields from the first post at the nth page of a category
Robert 12475 Jul 20, 2016, 12:12 AM
Post Re: [Robert] Fields from the first post at the nth page of a category
Andy 12422 Jul 20, 2016, 9:19 AM
Thread Re: [Robert] Fields from the first post at the nth page of a category
el noe 12444 Jul 20, 2016, 5:51 AM
Post Re: [el noe] Fields from the first post at the nth page of a category
el noe 12446 Jul 20, 2016, 5:52 AM