2 Million Posts???

[voclain]

My forum is about to hit 2 Million POSTS!!!! I personally think this is a huge millstone!

I would like to do like APPLE recently did for iTunes....I want to reward the person who is the "OFFICIAL" 2 millionth poster.

Can ya'll think of a way for me to KNOW for sure who that person is???

LET ME KNOW YOUR THOUGHTS???!!!

Kirk

[Seven Skins]

You may run a query and find the username.
But keep in mind:
- it will not take into account of deleted posts etc
- if you have editd the database manually then it may give you incorrect answer.
- etc...

SELECT * FROM `post` WHERE `postid` = 2000000

Edited:

Or this will show you 2,000,000th row in the database.

SELECT * FROM `post` LIMIT 2000000 , 1

.

[meaters]

That some big site, please show us

[Paul M]

The second query would be more accurate, tho you should order it by dateline (or postid).

[Max Taxable]