Last 5 messages now shown on front page

Join in these discussions today! Log in or register.
Wednesday 17 July 2002 9.50am
The subject line says it all - as from last night, the last five messages in the forum are displayed on the front page of the site, along with the most recent news, reviews and features.

I hope people find this useful

Website Editor
Wednesday 17 July 2002 5.14pm
...and I've just improved it so it shows the five most recent threads, rather than messages
Wednesday 17 July 2002 9.37pm
So that means I don't get to dominate the front page by tinkering with my subject line! Oh well.
Friday 19 July 2002 11.54am
Looks is if it needs some debugging James. But don't let it take you away from the sunbathing.
Friday 19 July 2002 12.00pm
No, I just changed it back to last five messages so that it more accurately reflected the latest activity in the forum.

I'm trying to get it to show each thread only once, but I can't get the SQL for that quite right.
Friday 19 July 2002 12.15pm
select distinct should sort it
Friday 19 July 2002 12.16pm
That's what I thought, but it doesn't. Or at least not the way I'm doing it
Friday 19 July 2002 3.57pm
select top 5 tmptopics from
(select topics as tmptopics, topicdate from topics group by topicdate asc)
Saturday 29 March 2003 5.00pm
...and after an extended absence this feature has now been returned to the front page.

Editor of the London SE1 website.
Subscribe to our SE1 Direct weekly newsletter.

To post a message, please log in or register..

Keep up with SE1 news

We have three email newsletters for you to choose from:

Proud to belong to

Independent Community News Network