Latest postings vs Latest answered threads (Features)

by Micha ⌂, Friday, April 20, 2007, 15:01 (4565 days ago)


I have on my site a small script which list the last answered threads (for example: see the 2th headline Forenbeiträge)

The sql-query is

$sql = "select `id`, UNIX_TIMESTAMP(time), `subject`, `name`, `category` from (select `tid`, `time`, `id`, `subject`, `name`, `category` from `".$db_settings['forum_table']."` order by `time` desc) g1 group by `tid` order by `time` desc limit 0,5";

this one works with "mein kleines Forum" version 1.7. I think it's better to see the aktive threads than the last postings.


applied-geodesy.org - OpenSource Least-Squares Adjustment Software for Geodetic Sciences

Complete thread:

 RSS Feed of thread

powered by my little forum