Blog
Developers
Careers
Support
Contact
Gossamer Threads
Solutions
Results
About
Mailing Lists
Resource Centre
Forum
Tools
Home
Who's Online
Tags
Favourites
Login
Forum Search
(
Advanced Search
)
This forum
This category
All forums
for
Home
:
Products
:
Gossamer Links
:
Version 1.x
:
Widgets..please read
Previous Thread
Next Thread
Print Thread
View Threaded
Oct 27, 1999, 1:47 AM
Digital Concepts
User
(77 posts)
Oct 27, 1999, 1:47 AM
Post #1 of 3
Views: 1828
Shortcut
Widgets..please read
Any chance you can convert the LastLink 1.99 mod http://www.gotzespace.dk/books/linksmod/lastlink.txt to LinksSQL for me??
Pretty please ... with sugar on top?
Chris
Oct 27, 1999, 11:17 AM
widgetz
Veteran
(2260 posts)
Oct 27, 1999, 11:17 AM
Post #2 of 3
Views: 1766
Shortcut
Re: Widgets..please read
In reply to
i'd imagine it to be like this:
Code:
my $number = 5;
my $offset = $LINKDB->total() - $number;
$sth = $LINKDB->prepare ( " SELECT * FROM Links LIMIT $offset, $number ");
$sth->execute() or die $DBI::errstr;
my ($lastlink, $link);
while ($link = $sth->fetchrow_hashref) {
$lastlink = &site_html_link ($link);
}
just some code whipped up.. dunno if it will return the right links.. but just try it
jerry
Oct 27, 1999, 12:05 PM
Alex
Administrator
(9387 posts)
Oct 27, 1999, 12:05 PM
Post #3 of 3
Views: 1771
Shortcut
Re: Widgets..please read
In reply to
Or try:
$hits = $LINKDB->query ( ID => '*', sb => 'Add_Date', so => 'DESC', mh => 5 );
if ($LINKDB->hits) {
foreach my $link (@$hits) {
$link = $LINKDB->array_to_hash ($link);
$last_link .= &site_html_link($link);
}
}
Cheers,
Alex
Previous Thread
Next Thread
Print Thread
View Threaded