need help,

tipsi · 08-18-2002, 12:28 PM

Hello!!!!!
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.

Phip · 08-18-2002, 06:10 PM

your question is pretty unclear and a little bit of code of anything would help.

rynox · 08-20-2002, 08: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...

Code:

SELECT Title, Author, [Date] FROM msgbd

Now check out this query...

Code:

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.

rynðx