Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

most recent 10 links

Sep 7, 2001, 6:19 AM
michelb
Novice (30 posts)
Sep 7, 2001, 6:19 AM
Post #1 of 6
Views: 1935
Shortcut
Quote Reply
most recent 10 links
Hi,

How can y do to have the most 10 recent link in the homepage?


Sep 7, 2001, 7:04 AM
Stealth
Veteran (17240 posts)
Stealth's avatar
Sep 7, 2001, 7:04 AM
Post #2 of 6
Views: 1856
Shortcut
Quote Reply
Re: most recent 10 links In reply to
I believe that codes were provided before in this forum for creating a GLOBAL tag that could be applied to the home.html template and other template files.

Basically, you will need to use the following query (for MySQL)....

Code:

SELECT *
FROM Links
ORDER BY LinkID DESC
LIMIT 10


========================================
Buh Bye!

Cheers,
Me
Sep 7, 2001, 7:11 AM
michelb
Novice (30 posts)
Sep 7, 2001, 7:11 AM
Post #3 of 6
Views: 1853
Shortcut
Quote Reply
Re: most recent 10 links In reply to
Thanks

I'm using links sql 2.0.4, and wherre can i place this code
Thnak you


Sep 7, 2001, 7:11 AM
Stealth
Veteran (17240 posts)
Stealth's avatar
Sep 7, 2001, 7:11 AM
Post #4 of 6
Views: 1861
Shortcut
Quote Reply
Re: most recent 10 links In reply to
Search this forum for Global Tags and you can apply codes that Alex has provided recently for creating a global tag, but using the query I provided.


========================================
Buh Bye!

Cheers,
Me
Sep 7, 2001, 10:11 AM
Alex
Administrator (9387 posts)
Sep 7, 2001, 10:11 AM
Post #5 of 6
Views: 1861
Shortcut
Quote Reply
Re: most recent 10 links In reply to
Or use http://gossamer-threads.com/...orum.cgi?post=157376

Cheers,

Alex

--
Gossamer Threads Inc.
Sep 7, 2001, 9:03 PM
Beck
User (185 posts)
Sep 7, 2001, 9:03 PM
Post #6 of 6
Views: 1818
Shortcut
Quote Reply
Re: most recent 10 links In reply to
 
Hi,

Send private to me with your email address. I will send you the pluggin can display top 10 site or n site. Because I haven't got my own website.

Cheers,

Beck