How do I order my loop query?

The Problem

$my_posts doesn’t contain any posts. It contains post IDs and likes. And you’re dropping both into post__in, which can’t work. I guess even the number of posts wouldn’t work if the plugin(?) wouldn’t add any post with a 0-x integer to the db-table per default.

The Debug

Try the following:

$my_likes = $wpdb->get_col("SELECT like_pid FROM wp_likes_count ORDER BY like_count DESC");
echo '<pre>';
print_r( $my_likes );
echo '</pre>';

which will likely show you an array containing two sub-arrays.

Way to a solution

Then try to get the sub-array you need and drop it into your query. Example: 'post__in' => $my_likes['like_pid'].

The Plugin

Anyway, a plugin should store something like this in the post_meta table in a field and not add an unnecassary table for something like that. There should be a facebook plugin by otto in the wp.org repo. This one’s much stronger, better written & by a trustable author. You should consider switching.

Related Posts:

  1. How to iterate through database until it find a match
  2. Generating a perfect loop
  3. wpdb inside foreach loop only returns first result – 2 other similar cases found [closed]
  4. Exclude Posts Using Meta Query and User Meta
  5. Use Loop or direct database query?
  6. Jquery Slider for profile template
  7. Get excerpt using get_the_excerpt outside a loop
  8. Retrieve each widget separately from a sidebar
  9. Should I use loop in the single.php file?
  10. wp_list_categories: get latest featured_image of category
  11. Where should I use post_class()?
  12. get_the_foo() in the loop – does it perform another query?
  13. Exclude filter on front page
  14. category__not_in — anyway to use category name instead of id?
  15. Is it possible to display previous post revision?
  16. Check if date of post is yesterday
  17. Exclude first 2 posts with meta_key from loop
  18. Fix inefficient loop breaks post.php on form submit
  19. Make a custom loop inside single.php with pagination
  20. Why do I get `Call to a member function have_posts() on a non-object `? [closed]
  21. Help with Changing loop.php?
  22. Get Pagination (WP-PageNavi) not to work
  23. Filtering The Loop For Single Page and Blog Page
  24. the_content() seems to block my ACF-code
  25. Pulling current post/page data into header.php
  26. Loop and Page template : my WP_query don’t take args
  27. How to split a loop into two columns
  28. Category Ajax call
  29. Transient loop issue
  30. popular post weekly and monthly
  31. Loop in Related Posts WordPress
  32. How do I go about looping through a advanced custom field on a particular page inside of another page
  33. Template structure
  34. The Loop – mixed ASC and DESC order
  35. Filter the_posts doesn’t work on search page
  36. Custom Loop Using Shortcode in Custom Page Template
  37. Listing subpages title and content and styling the first iteration differently
  38. Cannot retieve the_content() and the_author() – both returning empty strings
  39. How to order by multiple fields using standard query_posts?
  40. How to get the excerpt for is_home() outside of the loop isn’t working
  41. Make loop alphabetical
  42. How to check if a product is purchased within the last 365 days before displaying something
  43. How do I get my loop.php to properly paginate?
  44. Custom loop ordering not working
  45. First archive page with a few posts
  46. Loop through ACF taxonomies and output associated posts
  47. How to get user ID’s from multiple usernames?
  48. How to display first post
  49. Pagination on custom post type on front-page.php
  50. get_template_part() Not Working in Loop
  51. Query posts only with actual text content (not including shortcode or images)
  52. CPT while loop not working
  53. Problem with Front-Page.php loading recent posts
  54. Default featured image set as background image [closed]
  55. Breaking up the results of a loop
  56. Where to add offset?
  57. How to synchronize The Loop with the max post per page?
  58. How to add a byline to all the pages?
  59. How do i create a list-posts-page?
  60. Exclude posts based on an array
  61. Displaying member join date on page
  62. Ascending order has strange effects on wordpress loop
  63. Is file_exists() compatible with timthumb.php? [closed]
  64. List ALL posts by author on author archive
  65. get post images to link to external sources
  66. Using is_page_template inside loop
  67. Archive: Lists itself
  68. How to show the last article in a different way in my blog?
  69. Can’t limit posts_per_page in loop
  70. Slug is changing when I use WP_Query in a metabox of a post
  71. How to fix pagination for custom loops?
  72. Check to see if a field is within an array in twig
  73. Custom loop not working in singular.php, working in other pages
  74. Strange problem with wp_get_attachment_image_src database (db) query count
  75. How to include posts from one category, into a separate category of posts?
  76. how do i make this loop work
  77. Archive sorted by month – separate
  78. Making a specific page wordpress compatable that is not index
  79. One page loop issue with posts
  80. Humanmade | Custom meta box class: How to display a repeatable meta box group?
  81. Can’t print out returned value
  82. change the_content images for different sizes (Desktop, tablet, mobile)?
  83. Get query result before posts are displayed?
  84. WordPress Group By Problem
  85. Home page loop with pagination problem
  86. WooCommerce custom loop pagination on front page
  87. Eliminate duplicates in a foreach loop [closed]
  88. Tag custom loop show posts
  89. While loop inside another while loop
  90. get_page() unlike Loop returns the post content without html tags. How can I fix this?
  91. Problem with ms-thumb-frame-selected class in Master Slider
  92. I want the first post on my home page to be lengthier than the rest (example included)
  93. Loop with Custom Post Type Taxonomies and Interstitial Code
  94. Question about custom plugin
  95. loop mix my child-category and parent-category
  96. How can you make it so the comment box shows on some pages or posts but not all?
  97. Insert multiple custom components after x-number of posts
  98. wp_mail sending only once inside foreach loop
  99. How to use orderby on meta_value when using Pods custom database table storage
  100. How to set and retrieve cookies while in the loop
techhipbettruvabetnorabahisbahis forumutaraftarium24edueduseduedueduseduedueduedusedus