I want to sort all comment descending programmatically, I found this Comments sorted by oldest first but I dont want use those modules or views solution.
anybody know how can I sort comment descending programmatically?
I means comments in below node(contents) , first ideal is get comments related to node by query and set orderby DESC but everything show reversed in thread mode, replies come above comment !!!.

  • Comments attached to a node or All comments in the website ? – Anil Sagar Mar 1 '14 at 13:45
  • comments attached to node in view of node – Yuseferi Mar 1 '14 at 13:53
$query = db_select('comment') ->fields('comment', array('cid')) ->condition('nid', arg(1), '=');
$query->orderBy('created', 'DESC');
$result = $query->execute();
$cids = $result->fetchCol();
foreach($comments as $comment)  {
  //do some stuff with the comment
  • 1
    but do u think about how they come in thread mode ? replay placed above comment !!! (everything reversed>, tnx for you attention but this is not complete solution. – Yuseferi Mar 1 '14 at 17:08
  • Can you update your question with above details which will help others ? I mean thread mode.. – Anil Sagar Mar 1 '14 at 17:15
  • sure , I will update it . – Yuseferi Mar 1 '14 at 17:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.