Why Query is returning empty array?

you may need to wrap $slug in quotes

$course = $wpdb->get_results( "SELECT * FROM wp_posts where post_name="$slug"" );

Related Posts:

  1. meta_value timestamp older than now
  2. How to limit the number of posts that WP_Query gets?
  3. Should we trust the post globals?
  4. Random sort within an already sorted query
  5. How to know if get_posts() failed?
  6. post__in for get_posts with a dynamic array
  7. Using $wpdb to query posts with meta value containing current post_id
  8. WP_Query to work with custom view
  9. WordPress Number of Posts Not Changing With posts_per_page
  10. How to add posts to wp_query result?
  11. Should ‘setup_postdata()’ be reset with ‘wp_reset_postdata()’?
  12. Replace Main Query With Custom Query
  13. Search query – exact post title match
  14. posts_per_page doesnt work
  15. How to start with post number x?
  16. Exclude posts with empty post_content in wp_query
  17. Only display a certain number of posts, dependent on how many posts there are available in a query
  18. Improving WP_Query for performance when random posts are ordered
  19. Should $found_posts be returned as string in ‘found_posts’ filter hook?
  20. Get Posts that are in the current month or later
  21. How to do set post permalinks using 6 digit random unique function?
  22. Exclude the first ‘n’ number of posts of a tag from home page?
  23. posts_per_page option limits the number of Gallery items
  24. wp_posts table: safely remove unused columns to save database storage
  25. Inner join overrides Advanced Custom Fields plugin’s get_field [closed]
  26. Do not show children of a category
  27. Query for first 3 posts to change the look and feel
  28. Why posts array is empty?
  29. How to give classname to post if post has no content?
  30. Exclude some posts from displaying in wp_query based on some condition
  31. Related Posts function not working
  32. How to retrieve certain number of images from a wordpress post?
  33. How to convert query sql to shortcode in wordpress?
  34. How Can I Always Display A Particular Post First Using WP_Query?
  35. WordPress Query – Display 5 posts (same post type), each from a given tag
  36. filter posts based on menu_order
  37. Show 5 posts and than 3 posts offset with pagination
  38. wp query custom orderby not custom field
  39. Query post by meta key of another table
  40. Sort / Filter Queries
  41. Advanced Post Display/Pagination/Ordering
  42. Why I obtain this WP_Query strange behavior trying to select posts having a specific tag?
  43. Why I have this strange behavior when I try to exlude the featured post from posts visualization?
  44. Displaying Results From Custom Taxonomy Query
  45. WP_Query retrieve custom posts but not the post showing
  46. Wp_query WooCommerce products
  47. WP_Query post_tilte search in posts table
  48. The next_posts_link() works only with original $wp_query
  49. Accessing the post content with WP_Query
  50. How to make an activities stream mixing posts and comments?
  51. How to output comments number of a post per day?
  52. How can I get all posts data from within a paginated search result?
  53. If specific user role then sticky post
  54. Display posts with comments closed, with pagination?
  55. Only display posts after current date
  56. I want to query posts in monthly basis
  57. Custom WP_QUERY $args
  58. Limiting the number of posts in WP_Query leads to unexpected result
  59. WP_Query Authors OR Categories
  60. get query() without post content?
  61. how to change the number of posts returned in a specific loop without making it global?
  62. Dynamically switch template on click
  63. Get all custom post types excepted some…
  64. Get all comments of author’s posts
  65. post__in not working with pre_get_posts, but post__not_in does work
  66. Displaying post excerpt using wpdb query
  67. Query posts and filter at query time by value of custom meta
  68. Getting blog pagination to work on page set as front page
  69. search blog posts by author first name and or last name
  70. Very complex post query
  71. Delete post revisions only for a single post
  72. unique post in “$args” of wp_query display more than one post
  73. How to display post list in a table layout (multiple queries in single loop)
  74. Not all posts showing in query
  75. When WP_Query only returns 1 post, how do I automatically redirect to that post?
  76. WordPress query portfolio posts
  77. Get latest author posts inside the loop
  78. Display 3 posts with different HTML markup using a loop
  79. How to show multiple posts thumbnail, title and date in widget
  80. Group first, 2nd, 3rd, etc posts by category terms
  81. Manipulated offset and pagination, can’t display last post anymore
  82. Query to fetch custom taxonomy along with post title
  83. How to fetch courses in all languages in WordPress?
  84. How to display particular set of wordpress post on a webpage?
  85. show loop id post , only first id can read
  86. Is it possible to query a category with specified posts?
  87. Query posts from newest category
  88. WordPress loop uses unmodified posts array, why?
  89. Show posts between two Custom Fields date
  90. Query to get data of a post, if in category?
  91. Order posts by custom field
  92. Ordering posts alphabetically by meta keys and title
  93. Grab next post title in archive page
  94. Remove duplicated posts in the loop if post has more than one category
  95. Continuous listing from a custom field
  96. How to store post rating system data post independent?
  97. Why I getting only 1 post?
  98. First post in loop displays twice
  99. Display posts with id equal to relationship value
  100. Sort Posts Alphabetically Based on Specific Category (Divi)