... because I can't ORDER BY

ChrisB — Mon, 21 Aug 2000 07:23:00 +0000

... because I can't ORDER BY (desc) within the GROUP BY statement, that's exactly my problem. Or do you know how that would be possible?

Thanks,

Christian Becker

Randall — Mon, 21 Aug 2000 06:06:37 +0000

Why don't you try sorting them by DESC? Just an idea, thats how I do it on my forum (nobody uses it, talkback is more popular these days). ( http://dlo.net )

Hi, Since this is a high

ChrisB — Wed, 16 Aug 2000 17:16:00 +0000

Hi,
Since this is a high traffic site, I would prefer a single SQL query; doing such sub-queries for all 50 threads per page is way too much... any other ideas? =)

Thanks anyway!

Christian Becker

anti — Wed, 16 Aug 2000 16:05:57 +0000

This looks so familiar ...

My solution was to do it manually:

#pseudocode

$newest = '0000-00-00 00:00:00';
$posts = query( 'SELECT p.id, p.date FROM threads t, posts p WHERE p.threadid = t.id' );
while( $post = fetchrow( $posts ) ){
  if( $post[ 2 ]>$newest ){
    $newest = $post[ 1 ];
    $newestID = $post[ 0 ];
  }
}

query( 'SELECT login FROM posts WHERE id='.$newestID );

Obviously there is some errorchecking involved,
but that should do it.

If you want to see my (working) php version in action take a look at
http://www.biker-forum.com/whf/
btw:
That will be GPLed as soon as I cleaned up the code and fixed some security holes.

anti