How do i know who has made the 100,000 post?

[mcyates]

My forum is close to reaching 100,000 posts. i'm wondering how i will be able to determine who the member is who has made the 100,000 post? Is there a hack or anything which would let me know.

[Xenon]

an sql query would do the trick:

[sql]SELECT username
FROM post
ORDER BY dateline ASC
LIMIT 100000,1[/sql]

[mcyates]

thanks mate

[mcyates]

tht didn't actually do anything it just said:

Your SQL-query has been executed successfully

SQL-query : [Edit] [Explain SQL] [Create PHP Code]
SELECT username
FROM post
ORDER BY dateline ASC
LIMIT 100000 , 1

[Dean C]

Make sure you have the semi colon on the end

- miSt

[Xenon]

Your SQL-query has been executed successfully

well if you don't hav 100000 posts right now it wouldn't show anything

[mcyates]

oh that will be why then. Thanks a gain for the quick reply