how do i get the latest forum posts shown on main page ?

irishgeo

i am cuurently trying to redesign my site and i am trying to have the latest posts from the forum shown on my forum. how do i go about doing this.

I want it so that the latest posts show up. I am using php and phpbb for the forums.

An example of what i am trying to do is located here about halfway down the main page.

up.thedugout.net

Tom

I am doing this on QuinceyBand . It is in ASP using sql2000. Basically it is a select from the database of the top 5 posts order by desc LastPostDate. It is fairly straight forward to do from SQL as long as you have a LastPostDate on your header records.

irishgeo

can you show some code as viewing your html does not show up the actual sql

peterd

You could try some of these: http://www.phpbbhacks.com/searchresults.php?version=&query=latest

(This is presuming you're looking for a phpBB specific hack)

Tom

can you show some code as viewing your html does not show up the actual sql

Will do, as soon as I get home.

irishgeo

thanks guys got it working. i found a mod for it on phpbb.com
i never thought of it being a mod for the forums thats why i never looked there.

thanks anyway.