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 8496 Jul 18, 2016, 11:42 AM
Thread Re: [Robert] Fields from the first post at the nth page of a category
Andy 8305 Jul 19, 2016, 4:54 AM
Thread Re: [Andy] Fields from the first post at the nth page of a category
Robert 8304 Jul 19, 2016, 11:04 AM
Post Re: [Robert] Fields from the first post at the nth page of a category
Robert 8298 Jul 19, 2016, 11:05 AM
Thread Re: [Robert] Fields from the first post at the nth page of a category
Andy 8281 Jul 19, 2016, 10:49 PM
Thread Re: [Andy] Fields from the first post at the nth page of a category
Robert 8273 Jul 20, 2016, 12:12 AM
Post Re: [Robert] Fields from the first post at the nth page of a category
Andy 8227 Jul 20, 2016, 9:19 AM
Thread Re: [Robert] Fields from the first post at the nth page of a category
el noe 8252 Jul 20, 2016, 5:51 AM
Post Re: [el noe] Fields from the first post at the nth page of a category
el noe 8259 Jul 20, 2016, 5:52 AM