1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

User Order

Discussion in 'General PHP and MySQL Discussions' started by tafreehm, Jul 26, 2012.

  1. tafreehm

    tafreehm Well-Known Member

    Hello,
    The code is taken from a sidebar widget which supposed to show user whos birtday is today.
    PHP:
            $fetchOptions = array(
                
    'limit' => $widget['options']['limit'],
                 
    'order' => 'message_count',
                
    'join' => XenForo_Model_User::FETCH_USER_PROFILE XenForo_Model_User::FETCH_USER_OPTION,
            );
    now the problem is, it shows user with 0 post first.. How can I change its order to descending ?
    so the user with higher post will show first.

    Thanks
     
  2. MOZ

    MOZ Well-Known Member

    Add this 'direction' => 'DESC', after 'order' => 'message_count',
     
  3. tafreehm

    tafreehm Well-Known Member

    Thanks, but it did not change anything.....
    never mind, it worked !!
    Thanks a lot
     

Share This Page