phpfan101 Posted December 15, 2009 Share Posted December 15, 2009 I am trying to make a commenting system... all is working well but one thing, when a new comment is made, it is automatically at the top of all comments, i want it to read like a forum, oldest first, newest comment last... i !DO! use a unix timestamp to store the time the post is made in my mysql db, i just dont know how to efficiently use it to get my desired outcome, anyone? Link to comment https://forums.phpfreaks.com/topic/185295-ordering-replies/ Share on other sites More sharing options...
teamatomic Posted December 15, 2009 Share Posted December 15, 2009 Use the timestamp in an array and reverse sort. Link to comment https://forums.phpfreaks.com/topic/185295-ordering-replies/#findComment-978146 Share on other sites More sharing options...
phpfan101 Posted December 16, 2009 Author Share Posted December 16, 2009 i have them displayed in an array... how do i reverse sort?? Link to comment https://forums.phpfreaks.com/topic/185295-ordering-replies/#findComment-978152 Share on other sites More sharing options...
Kieran Menor Posted December 16, 2009 Share Posted December 16, 2009 If you're using MySQL, I guess this isn't the right place. But basically, ordering in MySQL works like this: SELECT `field1`, `field2` FROM `table` ORDER BY `field3` ASC Where field3 is the field you want to order by (duh), which would be the timestamp in your case. Also, ASC can be replaced with DESC to get the newest first. Link to comment https://forums.phpfreaks.com/topic/185295-ordering-replies/#findComment-978154 Share on other sites More sharing options...
teamatomic Posted December 16, 2009 Share Posted December 16, 2009 Yup, What boom.dk gave you will work but if you already have them in an array then arsort($array) HTH Teamatomic Link to comment https://forums.phpfreaks.com/topic/185295-ordering-replies/#findComment-978161 Share on other sites More sharing options...
phpfan101 Posted December 16, 2009 Author Share Posted December 16, 2009 lol, ty, that helped so much solved(and sorry about wrong section) Link to comment https://forums.phpfreaks.com/topic/185295-ordering-replies/#findComment-978166 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.