$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. What does this PHP function code mean? [closed]
  10. How do I append multiple taxonomies to the URL?
  11. WP 3.1 – archive pages for custom content types possible now without a plugin?
  12. Admin Post Update Redirection to Posts Screen
  13. How to not allow custom roles to edit published custom post types?
  14. Assign Page Template Within A Custom Post Type
  15. How to override parent theme function through the child theme [closed]
  16. Single Page WordPress CSS and JS links
  17. [Plugin: Posts 2 Posts] Changing display order of connections
  18. Disable dragging of metaboxes in custom post types?
  19. Error after deleting Custom Post Type with a function (no trash used)
  20. How to delete all posts from a custom post type?
  21. Structure for projects and clients
  22. Custom Post Type Alerts
  23. Why is my custom loop not filtering correctly nor paginating?
  24. Custom post types with custom directories
  25. Saving repeated option values in a custom query
  26. Calculating Bayesian average for custom post type
  27. How to best delete orphan wp_postmeta
  28. How to customize admin posts based on the user who is logged in
  29. Custom Post Type | Fatal Error on register_post_type()
  30. How to post twitter like updates on wordpress
  31. How to get all `supports` attributes by post type?
  32. apply filters only to specific post listing without check the url parameters
  33. Dynamically add / duplicate custom meta in custom post types
  34. How can I create a custom meta box to add an mp4 video to a page?
  35. Custom post type menu missing after 3.0b2 -> 3.1.2 upgrade
  36. Group posts by custom post type
  37. Plugin: register custom post types, child ready and performance best practices
  38. convert custom query to wp_query
  39. Permalink structure by Post Meta value
  40. Define new user capability for custom post types?
  41. 2 Templates 1 custom post type according url
  42. changing meta value and meta key of price field
  43. How to handle paged param in post and custom-post-type?
  44. How to import a custom MySQL DB table into a WordPress custom post type
  45. Shortcode to display Staff post type based on Location post type and Specialty post type
  46. Function causing the loop display posting more (empty)
  47. Adding the_content() in custom template email
  48. How to add attributes to taxonomies that may be different from post to post?
  49. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  50. Migrating a taxonomy’s tags to the native category
  51. How does order=asc effect a wp_query (its acting pretty weird in a loop)
  52. How to sort posts in a custom post type by title in ascending order by default?
  53. $post not working working in AJAX plugin with custom post type
  54. custom post type vs. conditionally displaying meta boxes for specific terms?
  55. Replace dynamically content in a custom database table when a custom post is created
  56. Navigate posts with different post type that are in the same categories
  57. Basic wpdb update question
  58. How to get the current category with custom posts
  59. WordPress Count posts within a custom post type
  60. Custom Post Types and Removing Slugs – should we do it?
  61. Need to have an archive widget which organizes and displays a custom post type using a custom date field
  62. Custom Content Type with No Page View
  63. Custom post type tags not showing in search
  64. Function to add custom HTML into head in custom post-type list page
  65. What is the best way to manage small blocks of content on my home page?
  66. One post auto attached to many another items
  67. How do I “trash” a custom post type post while logged in as Admin
  68. WP 3.1 custom post type permlinks
  69. Placing Admin Post Metaboxes in Tabs
  70. See if the email exists or not
  71. Auto update publish date of CPT Post if default post custom field value match to cpt post CF Value
  72. How can i display a taxonomy? i have created a plugin and then a custom type. and a taxonomy , also i have register it
  73. What is my error trying to create a new table in the database?
  74. Is it possible to create 2 unique titles for an Events custom post type: Upcoming Events and Past Events?
  75. Querying posts that don’t have a certain key value or don’t have the key
  76. wp delete duplicate entries of custom post types every 15 minutes
  77. How to Disable option of meta field if that option is selected for any other post in custom post type?
  78. Attempting to create custom “post” template, getting a 500 internal server error
  79. Update 2 wordpress tables at once
  80. Multiple WordPress Sites, Same Database but Filtered Content
  81. How to use costum database table for custom post type
  82. connect users to Custom post types
  83. Populate custom post type/custom fields from an external database
  84. Custom Pagination based on Custom Post Type
  85. Custom user roles
  86. One Post with different content, depending on a Page
  87. Create 2-layered dropdown menus for custom taxonomy and custom post type
  88. Custom Post Type
  89. Registering an optional custom post type from a plugin
  90. Shared Custom post type between WP network sites
  91. Query Distinct Taxonomies of Custom Post Type
  92. Custom metabox value not saving
  93. Cannot modify a registered custom post type rewrite slug
  94. Add Excerpt On Quicksand Plugin
  95. Select Menu for Custom post Type does not save
  96. Specifying Default Template for Hierarchal Custom Post Type [duplicate]
  97. Inserting two categories
  98. How to delete unnecessary custom post types in the UI
  99. Advise on Custom Taxonomies and Structure
  100. display posts, pages and custom post types from another wordpress site