08-18-2002, 01:28 PM
I have a forum(toastforum). Can any tell me how i can have last 10 or llast 5 post on mqain page on my website.
your question is pretty unclear and a little bit of code of anything would help.
08-20-2002, 09:29 PM
I have a Message Board type application that is used in a corporate Intranet environment where I did the same thing.
Note the example query...
SELECT Title, Author, [Date] FROM msgbd
Now check out this query...
SELECT TOP 5 Title, Author, Date FROM msgbd ORDER BY [Date] DESC
The TOP 5 clause specifies that only the first five tuples of the result set will be returned. Hope this example helps.