I have a problem with a forum I made for sometime ago.
The problem is that the entire forum is threaded..
Post 1
- Post 2
-- Post 3
And so on...
And every post gets a unix-timestamp when written into MySQL.
The problems lies in that when the world turned a billion, the sorting of the forum is screwed up.
Because it seems that 999 million comes before 1 billion when I pull it out of the database.
So all the posts made after the world turned 1 billion in unix, they get sorted last (desc sorting).
How can I make it so mysql really sorts by the timestamp correctly.
Now 999999999 comes before 1000000000 , this is really annoying.
Can anybody help!? I've searched the forum without any luck...
The problem is that the entire forum is threaded..
Post 1
- Post 2
-- Post 3
And so on...
And every post gets a unix-timestamp when written into MySQL.
The problems lies in that when the world turned a billion, the sorting of the forum is screwed up.
Because it seems that 999 million comes before 1 billion when I pull it out of the database.
So all the posts made after the world turned 1 billion in unix, they get sorted last (desc sorting).
How can I make it so mysql really sorts by the timestamp correctly.
Now 999999999 comes before 1000000000 , this is really annoying.
Can anybody help!? I've searched the forum without any luck...