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. How to make WP_Query faster when getting a post from one year ago?
  49. Wp_query loop is not working as it should
  50. Get current user, change users post status to published
  51. Show all posts from the tags without having to set all of them
  52. How to fetch posts that are stored in the different table than the default table (wp_posts)?
  53. Is it possible to query a category with specified posts?
  54. WordPress text field in array problem
  55. Displaying a specific sub-category’s posts from wp_query
  56. Query posts from newest category
  57. Random order of the 5 most popular posts
  58. My custom query is displaying random posts in random order
  59. Creating Ordered Query using Meta_key
  60. Sort Events by Venue Title – Sort Post set by related post ids
  61. Is there a global page/post/product/anything ID?
  62. Custom layout manager for posts
  63. Get query result according to merged array
  64. Blog only showing one post even though more published
  65. wpdb get_results() returns only 2 rows
  66. WordPress loop uses unmodified posts array, why?
  67. Display WordPress Post By Date
  68. Query post for today, if no post get the previous one
  69. Custom Select Query pagination not working properly
  70. GUID to related post not in current language
  71. I am not getting result from php function that is json encoded
  72. Get results from the main wp_query
  73. Query post category & remove any post id
  74. How can I display a specific number of post in a category via a url
  75. Show posts between two Custom Fields date
  76. Display the latest post from some selected authors
  77. WP Query between posts custom fields [duplicate]
  78. Query to get data of a post, if in category?
  79. Order posts by custom field
  80. Ordering posts alphabetically by meta keys and title
  81. How to show the posts list into a static page? Problems to use the loop into a static page
  82. Save/retrieve form data best practises for theme development
  83. Grab next post title in archive page
  84. How do I control the fallback query after the original query returned cero posts?
  85. Removing a post from the results of a WP Query
  86. Search Query that Includes Custom Table
  87. Remove duplicated posts in the loop if post has more than one category
  88. Query posts from a specific category and selected tag
  89. Continuous listing from a custom field
  90. Pagination for custom query won’t let me back on page 1
  91. Order posts by separate menu order for different sub-categories
  92. Retrieve latest post by multiple categories with ID
  93. Adding a category at even positions on main loop with modified pagination
  94. Query Posts From Multiple Post Types
  95. get_var result empty for query of custom table in plugin admin
  96. Sort post by category using HTML Select tag
  97. Make assigning post to a specific category equivalent to assigning it to all categories
  98. How to store post rating system data post independent?
  99. Update Post with Modified Data
  100. Multiple loops on a Search result page?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)