$wpdb is queried but results don’t show

Refer to the Codex page for setup_postdata():

Important: You must make use of the global $post variable to pass the post details into this function, otherwise functions like the_title() don’t work properly…

Also note that you can use WP_Query to do these queries, rather than writing raw SQL.

Related Posts:

  1. modify all posts of a category to “no comments allowed”
  2. Deleting Custom Post type data using mySQL command
  3. wpdb custom post_type problem
  4. $wpdb: Counting posts corresponding to 3 terms in 3 different taxonomies
  5. Insert post metadata for all posts in CPT at once if metadata no existent
  6. Convert simple SQL Query to WordPress query
  7. Why doesnt my tag page populate with this custom post type?
  8. Create a WordPress Database query to find users who purchased specific product through WooCommerce [closed]
  9. Is there a way to have the view link on manage posts page to open in a new window or tab?
  10. Getting rid of /my_custom_post_type/ in the single view URL
  11. Custom post type menu missing after 3.0b2 -> 3.1.2 upgrade
  12. Custom Post Type – List all attachments on Edit Screen
  13. Group posts by custom post type
  14. Custom Page that comes with preloaded content for the user
  15. How inefficient is it to use a Custom Post for 4-5 sentences & pull all to 1 page?
  16. How to check post type (to include custom css)
  17. How to customize a permalink (URL) structure?
  18. Plugin: register custom post types, child ready and performance best practices
  19. Display only one post each WEEK
  20. Add meta value to custom post type on publish
  21. convert custom query to wp_query
  22. How to Mass Delete Images from Media Library
  23. using $wpdb to get custom post type with term
  24. Permalink structure by Post Meta value
  25. How to integrate video slide using custom post types?
  26. Converting the_content string to an array?
  27. A question on creating filters for custom posts using taxonomy
  28. Conditional Query of Custom Post Type and custom taxonomy
  29. will post_id ever change? Can I safely use post_id for custom queries?
  30. List custom taxonomy specific to one custom post type
  31. Define new user capability for custom post types?
  32. How to allow visitors to enter custom post type?
  33. Is it possible to create relational metabox values in a custom post?
  34. Custom Post Type Query for Sidebar Doesn’t Work on Front Page
  35. Meta query for custom post type ignored in main query
  36. 2 Templates 1 custom post type according url
  37. How do I move/order posts with a tag to the end?
  38. changing meta value and meta key of price field
  39. Display custom fields from custom posts in RSS feed
  40. WordPress sort search results by custom order
  41. Use same slug base for Custom Post Type posts, and multiple taxonomy terms
  42. Hide parent categories when clicked, and show it’s childs
  43. Custom Path/Folder behind a custom post type
  44. Time based access control of custom post types – what is good approach?
  45. Show titles, date of all posts on single category page
  46. delete_published_posts does not work
  47. How to start a new post with custom Taxonomies already set?
  48. WooCommerce sort products by the actual product width(not the shipping width)
  49. Create a custom php page and load it at a specific slug
  50. Structure of data : CPT + terms
  51. How to handle paged param in post and custom-post-type?
  52. Default text in a specific post type, but not visible?
  53. Update postmeta Parent when post_status child change
  54. WP_Query custom post type query not showing the exact post type
  55. Assign External Database Queries to Global Variables and Make Them Accessible
  56. How to import a custom MySQL DB table into a WordPress custom post type
  57. Shortcode to display Staff post type based on Location post type and Specialty post type
  58. How to remove post listing page for a custom post type
  59. How to include term custom meta into the custom taxonomy term permalink structure
  60. Get terms that contain posts that in turn belong to other terms?
  61. How to Get WordPress custom post data in WooCommerce product meta panel? [closed]
  62. Function causing the loop display posting more (empty)
  63. A form that can save/edit after first input
  64. Adding the_content() in custom template email
  65. Cannot save CPT meta box
  66. non-hierarchical post type with hierarchical url structure
  67. Send notification to the admin when new custom post is submitted
  68. How do i search authors from search form using author’s name
  69. Allow users to create posts without logging in?
  70. How to add attributes to taxonomies that may be different from post to post?
  71. Pages are not saving due to custom post type
  72. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  73. wpdb custom tables without plugin
  74. Migrating a taxonomy’s tags to the native category
  75. wp_insert_post sometimes fails after API call
  76. How to produce a sub-page-system in WordPress
  77. Best structure / rewrite rules to achieve the following url
  78. don’t publish custom post type post if a meta data field isn’t valid
  79. How does order=asc effect a wp_query (its acting pretty weird in a loop)
  80. Save custom post type to external database
  81. How to sort posts in a custom post type by title in ascending order by default?
  82. Categorise Custom Post Types
  83. $post not working working in AJAX plugin with custom post type
  84. Proper way to display latest 5 posts grouped by post type?
  85. Detect inside a custom query the kind of post type to assign custom classes
  86. custom post type vs. conditionally displaying meta boxes for specific terms?
  87. Edit the_content() function so to add a div wrapper
  88. How do you make a custom post type items automatically delete items 3 months after publication?
  89. Custom Post Type & Custom Menu Walker to append custom class for active post types
  90. Number of posts in the archive
  91. custom post data – how to
  92. Ordering Submenu Pages in WP 3.1
  93. 404 Error on form submission within custom post type
  94. Custom URL redirect in WP
  95. Remove Quick edit for custom post type?
  96. Replace dynamically content in a custom database table when a custom post is created
  97. How to customize work area / admin area in a custom post type without plugins?
  98. How can I have different content for different countries?
  99. Change “empty trash” button text?
  100. WPDB for post count on post
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)