Last 5 messages now shown on front page

Join in these discussions today! Log in or register.
Wednesday 17 July 2002 10.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

James
Website Editor
Wednesday 17 July 2002 6.14pm
...and I've just improved it so it shows the five most recent threads, rather than messages
Wednesday 17 July 2002 10.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 12.54pm
Looks is if it needs some debugging James. But don't let it take you away from the sunbathing.
Friday 19 July 2002 1.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.
Matthew
Friday 19 July 2002 1.15pm
select distinct should sort it
Friday 19 July 2002 1.16pm
That's what I thought, but it doesn't. Or at least not the way I'm doing it
Matthew
Friday 19 July 2002 4.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: