Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Reading Latest Table Entries
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

_ENiGMA_
New Member

USA
82 Posts

Posted - 11 August 2001 :  16:00:54  Show Profile  Visit _ENiGMA_'s Homepage
I have a database named site.mdb and I would like to get the last 8 entries from a table called SITE_MEMBERS and write it into an html table. The primary key is an autonumber and the values I would like to write to the new html table are M_MEMBER and M_DATE. Could anyone help me out with this?

(FYI, it would also help me out with 3 other problems I am currently facing)

Thanks All!

PS, anyone know if reply notification will be put back on the these forums?


ENiGMA[RiA]

ariaclan.com Forums
http://www.wiktel.net/ariaclan/default.asp

Kat
Advanced Member

United Kingdom
3065 Posts

Posted - 13 August 2001 :  04:56:33  Show Profile  Visit Kat's Homepage

SELECT TOP 8 M_MEMBER, M_DATE from SITE_MEMBERS Order by MEMBER_ID DESC


This will return you a recordset with the last eight entries from the table (assuming your autonumber field is called MEMBER_ID). You can then loop around the recordset to display those fields as you like.

Does this help at all?

KatsKorner
Go to Top of Page

_ENiGMA_
New Member

USA
82 Posts

Posted - 13 August 2001 :  11:08:46  Show Profile  Visit _ENiGMA_'s Homepage
Thanks Kat! I'll check it out when I get home from work.

I appreciate it!



ENiGMA[RiA]
Go to Top of Page

Kat
Advanced Member

United Kingdom
3065 Posts

Posted - 13 August 2001 :  11:29:43  Show Profile  Visit Kat's Homepage
No problem. I hope you sort it!

KatsKorner
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.23 seconds. Powered By: Snitz Forums 2000 Version 3.4.07