View Single Post
Old 12-29-2004, 08:17 PM  
Varius
Confirmed User
 
Industry Role:
Join Date: Jun 2004
Location: New York, NY
Posts: 6,890
GFY post order problem...my solution for you Lens =)

I have noticed that posts are being shown in bad orders and believe I know your problem.

If you have multiple servers, their times are probably not synchronized.

The solution is to use the database's native function, for example if it's a unix timestamp in MySQL have your coder modify the places it inserts the time to do this instead:

BEFORE
timestamp_field='$time'

AFTER
timestamp_field=UNIX_TIMESTAMP()

This will ensure that no matter what server the post comes from, it gets the current timestamp of the DB inserted....and no more post order mixup

If that's not your problem, then nevermind this post
__________________
Skype variuscr - Email varius AT gmail
Varius is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote