News:

Wondering if this will always be free?  See why free is better.

Main Menu

Need Help, Posters in period

Started by Powerbob, September 02, 2009, 10:53:02 PM

Previous topic - Next topic

Arantor

Weird.

OK, let's try this.

SELECT poster_name, COUNT(id_msg) AS 'nposts', MAX(poster_time)
FROM `smf_messages`
GROUP BY poster_name
ORDER BY nposts DESC


This will get us the last post time per person.

Powerbob




My SMF 2.1 Beta test site; http://www.pplb.net/smf21/index.php

Arantor

I was hoping you were going to give me a few numbers from the right hand column too.

Powerbob




My SMF 2.1 Beta test site; http://www.pplb.net/smf21/index.php

Powerbob

I think I am going crazy here!

Just tried it again and the query worked! Go figure, it's beyond me?
Topic is now solved, thanks for all your help and sorry I took up so much of your valuable time.

Thanks
Bob



My SMF 2.1 Beta test site; http://www.pplb.net/smf21/index.php

Arantor

No worries to take up time - if you've got a problem with SMF, no matter how small or huge, that is what this forum is for, so we can figure it out.

I'm not sure what went on there, but if it's working now, that's all good.

Advertisement: