Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

MOD: Latest categories added?

Quote Reply
MOD: Latest categories added?
Hi all,

Would it be possible to have a new 'section' to show the latest categories that have been added?

I'm thinking a fair bit of code is already there for 'New Links' and it would just need tweaking for the categories table (with the addition of a 'date added' to the category table)?

Any thoughts welcome Smile

All the best
Shaun

PS. I'm looking for this because I'm still adding links, but I'm creating a lot of new categories to accommodate them and I'd like my visitors to see that a lot of work is going on in the background!
Quote Reply
Re: MOD: Latest categories added? In reply to
For what version of Links SQL...v.1.13??? Or the NEXT GENERATION?

Regards,

Eliot Lee
Quote Reply
Re: MOD: Latest categories added? In reply to
SELECT * FROM Categories ORDER BY ID DESC LIMIT 1

lol.. sorry.. i forgot how to use links sql

Jerry Su
widgetz sucks
Quote Reply
Re: MOD: Latest categories added? In reply to
Thank's for the replies:

I'm using V1.13 and having thought about it a bit more, I'd need to add a 'isNew' field also, so it can turn the latest categories on/off as it does with the links.

I'll have a play around with it and see what I can come up with, I just thought I'd ask here first to see if anyone had done anything similar before Smile

All the best
Shaun