Hello,
I had a contest on my forum but i couldn't find the winner. I want to find who has the owner of 1.000.000th post on my forum. Post id is greater than 1 million because of deleted posts.
I used this sql code but i get me wrong result.
This code gets me a message that posted 12 days ago(ID is 1.063.664). But on my forumhome statistics, today i passed 1 million.
So, i'm confused, how can i solve this and give the winner's prize?
I had a contest on my forum but i couldn't find the winner. I want to find who has the owner of 1.000.000th post on my forum. Post id is greater than 1 million because of deleted posts.
I used this sql code but i get me wrong result.
Code:
SELECT * FROM post ORDER BY postid LIMIT 1000000 , 1
So, i'm confused, how can i solve this and give the winner's prize?

Comment