Mysql query not working on WordPress 4.2.2

Try “bootstrapping” WordPress for your custom script first: include '../../../wp-load.php' (you might need to adjust the path for your needs).

Then you can safely use the $wpdb class, such as $wpdb->get_results and other goodies. Don’t forget to escape/clean your incoming data, if any.
WordPress documentation on $wpdb

PS: always try to use “builtin” functions. The codex above is gold.

Related Posts:

  1. Get all image from single page using this query
  2. simple sql query on wp_postmeta very slow
  3. wordpress query – orderby child post date
  4. Add multiple value to a query variable in WordPress
  5. wp_dropdown_categories with multiple select
  6. How to tune search argument in WP_Query to show only exactly the same results?
  7. How to get my loop to pull posts into three columns
  8. Custom $wpdb Query for Custom Post Type by Category
  9. Can’t pass table to $wpdb->prepare
  10. How to extract all ID variables from a query string?
  11. Date query year and month OR just year
  12. Are database queries created using WordPress filters protected from SQL injection?
  13. get post id using the $query_vars variable
  14. Remove Unnecessary Mysql Query
  15. How to remove duplicate query on page load or make them cacheable
  16. Is there a conditional tag for latest post or do i need a query?
  17. wpdb::prepare() isn’t working
  18. How can I apply a meta query for a single custom post type in the main query?
  19. get_posts() loop returns the same the_title() for each post
  20. How to check current user in meta value array in WP_Query meta_query
  21. Using pre_get_posts to target a query in the sidebar
  22. How select a specific query when setting offset?
  23. Change media attachment author via mysql query
  24. Get post according to current taxonomy
  25. Temporarily storing main search result
  26. Help with MySQL to $WPDB query
  27. Ordering by a metadata subfield in WordPress?
  28. Alter query with posts_clauses to retrieve NULL values last
  29. sql select query in wordpress ‘page’ [closed]
  30. wpdb->term_taxonomy count posts from both published and private posts?
  31. Query based on title, with ‘compare’ => ‘IN’
  32. Issue with using add_rewrite_rule() for post querying custom fields
  33. Group custom post listing in admin section
  34. Plugin will sort users by usermeta
  35. problem with sql query in wordpress plugin
  36. Attempt to improve WP search, can someone check my SQL query?
  37. WordPress Query orderby title with UTF8 string in title
  38. Searching With Apostrophe
  39. Query posts according to specific post meta values
  40. List author’s posts with SQL
  41. Where is the query in wp-login.php
  42. Order posts by recent comments
  43. query if page has not child
  44. empty query breaks other queries
  45. Problem in exploding the_content to array
  46. get_posts showing only 5 posts. (nopaging and posts_per_page -1 not working)
  47. Order by title – but now built in wordpress func, sort the_title
  48. Display posts between two particular dates
  49. pre saved posts query from db options table
  50. What is wrong with my wp query, cant exclude the category that i want
  51. Order posts by date, but also give priority for a specific term
  52. $post->ID not working in combination with a custom query
  53. Custom Query returns array, but I can’t see it’s elements
  54. How to insert Collate into WordPress search query?
  55. Combine “Exclude” Query in functions.php
  56. Optimize slow SQL query for multiple meta values
  57. prepare function sql safe method
  58. WordPress SQL query to tag all posts containing a specific word on title
  59. get_post_meta with WP_query
  60. Order terms by count – missing terms
  61. Querying Advanced Custom Fields
  62. How to rearrange a pool of posts joined using two queries?
  63. wpdb update multiple row?
  64. How properly create a blog template for wordpress?
  65. Can I include get_posts in this array?
  66. Is there a way to add a link directly into this media query?
  67. Custom query Custom-Post-Types creates error
  68. Formatting a date/time returned from a custom $wpdb query
  69. Rewrite rule for query params
  70. meta_query not working
  71. Cannot get sql request from Query object?
  72. Hook into the Admin Dashboard and redirect users
  73. Displaying data from custom table
  74. SEO friendly query vars
  75. Question about of query
  76. Prevent versioning for .woff (font) files
  77. Orderby event date (if it exists) or post date (if it doesn’t) – how to reorder posts based on meta value OR date
  78. Is there any way to get all custom posts and all custom terms with it’s meta in few queries?
  79. Modify behaviour of “s” parameter in wp_query
  80. OR condition not working
  81. Query not returning child posts for any parent post ID
  82. How to make MySQL search queries with quotes
  83. Limiting a filtered query
  84. Use $wpdb->get_results with filter based on array
  85. Add Hook for clearing transient when post is added
  86. Archive query not working correctly
  87. Custom MySQL Query for Post and Post Meta
  88. How to have more post in a page than in your home page
  89. Show links to child pages on both parent AND child pages
  90. learn to run wpdb class
  91. Display old posts if no future posts exist
  92. Access Tables with number prefix
  93. Modify Global Posts Plugin
  94. How to reference same column name but different table in custom db query
  95. Retrieving custom field array value through db query
  96. how to add a read more button to my blog page?
  97. SQL Query : how copy all tags of post into their post content in wordpress by sql query
  98. Query parsing only author ids
  99. 3 queries to update WordPress
  100. How to figure out correct wp_options to have autoload=’yes’