For retrieving the newsitem select top 1 * from news order by id desc
For retrieving the links select id from news order where id not in (select top 1 id from news order by id desc) order by id desc For additional explanation on how to get it all on your screen: http://www.learnasp.com/learn/dbtablegetrows.asp Use the id to link to the newsitems Hope this is enough to help you along. ----- Original Message ----- From: "Valter" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, March 04, 2005 9:54 AM Subject: [AspClassicAnyQuestionIsOk] Problem with db > > > I need to display on my web page the last of the news i have i my db > table. Also, in the same page i need to show a list of links to all > the old news with exeption, of course, of the last one i already > dispay in full on the page. > How can i do that? > Thank you > Valter > > > > > > > Yahoo! Groups Links > > > > > > > > > -- > No virus found in this incoming message. > Checked by AVG Anti-Virus. > Version: 7.0.308 / Virus Database: 266.5.7 - Release Date: 3/1/2005 > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
