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:
absorbation
Elite Member
*****

Avatar

Posts: 3636
Reputation: 81
– / Male / Flag
Joined: Feb 2005
RE: MySQL Date/time help?
You could try using a timestamp instead, which gives you a lot more flexibility when handling time and should produce your database in chronological order.

Are you just attempting to show the latest records first? If that is the case using your primary key (typically 'id') and order them from the top. If you don't have a primary key, I highly recommend using one, their vital when it comes to using relationships.
01-06-2010 06:15 PM
Profile PM 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