Jump to content

Sorting Issue


chrisuk

Recommended Posts

Just noticed a funny thing with my sorts - this data is set to sort by Date Desc - notice how the morning ones are shown first, in decending order, then the afternoon, in descesnding order....

 

Any ideas? It's confused me somewhat.

 

Date Logged                 

28 Feb 07 8:58am

28 Feb 07 8:56am     

28 Feb 07 8:35am     

28 Feb 07 13:14pm   

27 Feb 07 13:45pm   

 

thanks

Link to comment
https://forums.phpfreaks.com/topic/40517-sorting-issue/
Share on other sites

currently set to:  "SELECT * FROM `Issues` ORDER BY `logged_date` DESC";

 

as for the formatting...

 

when an entry is made into the database the date is read from a variable and then inserted...ie:

 

 

$sysdate = date("Y-m-d h:i:s");

"INSERT INTO Issues VALUES ('', '$sysdate'..etc")

Link to comment
https://forums.phpfreaks.com/topic/40517-sorting-issue/#findComment-196059
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.