What happened to the Messenger Plus! forums on msghelp.net?
Shoutbox » MsgHelp Archive » Skype & Technology » Tech Talk » MySQL Date/time help?

MySQL Date/time help?
Author: Message:
Lou
Veteran Member
*****

Avatar

Posts: 2475
Reputation: 43
– / Male / Flag
Joined: Aug 2004
RE: MySQL Date/time help?
quote:
Originally posted by Spunky
quote:
Originally posted by absorbation
Use your own personal identifier e.g. id > steam_id > desc > time :)

That won't work if the timestamps don't relate to the id or steam_id. For example, I could have the lowest id (1), but the most recent time stamp (say now for example) and a steam_id of 748476

I'd show up before someone with the earliest time stamp, but with a higher id
Usually, when a record is added, the unique id is set to that record, one above the last one. Thus, organizing in desc order by unique id, will give the newest records first :undecided:.
[Image: msghelp.net.png]
The future holds bright things in it\\\'s path, but only time will tell what they are and where they come from.
Messenger Stuff Forums
01-06-2010 07:35 PM
Profile PM Web Find Quote Report
« Next Oldest Return to Top Next Newest »

Messages In This Thread
MySQL Date/time help? - by Jimbo on 01-06-2010 at 05:33 PM
RE: MySQL Date/time help? - by absorbation on 01-06-2010 at 06:15 PM
RE: MySQL Date/time help? - by Jimbo on 01-06-2010 at 06:51 PM
RE: MySQL Date/time help? - by absorbation on 01-06-2010 at 07:10 PM
RE: MySQL Date/time help? - by Spunky on 01-06-2010 at 07:20 PM
RE: MySQL Date/time help? - by Lou on 01-06-2010 at 07:35 PM
RE: MySQL Date/time help? - by Spunky on 01-06-2010 at 07:42 PM
RE: MySQL Date/time help? - by Jimbo on 01-06-2010 at 08:14 PM
RE: MySQL Date/time help? - by Adeptus on 01-07-2010 at 12:03 AM
RE: MySQL Date/time help? - by Jimbo on 01-07-2010 at 01:42 PM
RE: MySQL Date/time help? - by Adeptus on 01-07-2010 at 03:51 PM


Threaded Mode | Linear Mode
View a Printable Version
Send this Thread to a Friend
Subscribe | Add to Favorites
Rate This Thread:

Forum Jump:

Forum Rules:
You cannot post new threads
You cannot post replies
You cannot post attachments
You can edit your posts
HTML is Off
myCode is On
Smilies are On
[img] Code is On