[AndrewD]

Originally Posted by mathias

I want to put the last 10 links on a non vb page how would I go about that?

So you need to grab them from the database? This sql grabs the last 10, most recent first.

SELECT 
link.linkid AS linkid, 
link.linkname AS linkname, 
link.linkuserid AS linkuserid, 
link.linkusername AS linkusername, 
link.linkurl AS linkurl, 
link.linkdesc AS linkdesc, 
link.numrate AS numrate, 
link.totrate AS totrate, 
link.linkhits AS linkhits, 
link.linksize AS linksize, 
link.linkstatus AS linkstatus, 
link.linkdate AS linkdate, 
link.linkmoderate AS linkmoderate, 
ltoc.catid AS linkcatid 

FROM local_linkslink AS link 
LEFT JOIN local_linksltoc AS ltoc 
ON link.linkid = ltoc.linkid 

WHERE link.linkstatus>0 

ORDER BY 
linkdate DESC, 
linkname ASC, 
linkcatid ASC

LIMIT 10