Using wpdb prepare with a variable, turns it into a big string

Turns out prepare had bad syntax, and my table was incomplete due to a bad csv import. So, lesson learned, check the manual for syntax, and check (double check!) your tables. Thanks to Tom and Sally for their comments, they helped me to re-think what was I doing wrong.

Related Posts:

  1. WP Query Args – Title or Meta Value
  2. WordPress Pagination Not Working – Always Showing First Pages Content
  3. Whats the difference between post_limits and pre_get_posts?
  4. Order Search Results Page by meta_value If no Value Return Remaining Results
  5. Query WooCommerce orders where meta data does not exist
  6. How to get Page/Post Gallery attachment images in order they are set in backend using WP_Query()?
  7. What exactly does the ‘s’ parameter search for in WP queries?
  8. Query all posts where meta value is empty
  9. get_posts not finding argument: post_name
  10. get query’s query string
  11. Show only oldest post by author
  12. Revolution Slider Orderby Two Custom Fields
  13. Calling a custom excerpt function in a local loop
  14. Get random terms
  15. Dynamically Override Fancy Title – Part II
  16. Count posts returned by get_posts in external PHP script
  17. How to run query inside a class with namespace?
  18. Modify existing query and change order of posts
  19. Why does the_content not work like others for a set post id?
  20. How would I format a query that depends on post parent taxonomy
  21. Rewrite rule to prettify two $_GET variables while in a new endpoint from a page
  22. Creating a custom search for a specific post type
  23. How to add post_distinct filter to WP_Comment_Query?
  24. WP_Query Group by Author and Order each group DESC
  25. List only posts from specific category on category page
  26. Most popular post for last 7 days
  27. How to filter, restrict and return posts based on custom user meta information
  28. Masonry, WP_Query & paged – first page repeating, second page not loading
  29. Query posts intersecting tags and categories
  30. WP_Query ignoring tax_query when is_singular
  31. WP_Query() order by post content lenght?
  32. REST API: Limit Read Permissions for Default Endpoints
  33. Excluding pages in WP_query using ACF
  34. reset to main loop doesnt work
  35. How to sort post by custom table value
  36. Pagination on static Posts page
  37. WP_Query : Search and Filter Using custom field AND/OR custom taxonomy
  38. Query all posts if multiple meta key don’t exist
  39. WP_Query with rewind_posts creates duplicate titles
  40. Is it safe to access the underlying mysqli object from \wpdb for custom queries?
  41. wp_query to print posts if have X custom field value
  42. Rewrite gets completely ignored
  43. Check for the main query from the template
  44. How do I turn these values from MYSQL into an array
  45. get_posts() and global variables
  46. Use Ajax To filter posts?
  47. Should $query-> be used with conditional tags?
  48. Get user posts with custom WP_Query on author.php
  49. How to combine two WP_Query objects?
  50. WP_Query author parameter not working
  51. How to order posts on each different category?
  52. Getting the post terms ‘wp_get_post_terms’ per post when within the functions.php file
  53. Posts Query | Query to only show sub categories
  54. Is it possible to retrieve posts depending on meta_key LIKE condition? [duplicate]
  55. WP Query and date format
  56. How to Order By Two Custom Fields?
  57. Display specific page (that is child) content on parent page
  58. WP_query problem -spurious results
  59. Avoid duplicate while merging two query post
  60. ajax wp_query conditional tags not working
  61. Comparing 2 Decimal Numbers from custom fields and displaying posts
  62. Query Not working as expected
  63. How to create single page site in WordPress
  64. max_num_pages says 4, yet I am only able to navigate to the third page
  65. Execute PHP function inside the admin area
  66. paginate_links appearing on page but it doesn’t actually paginate – pagination on a static page with a dynamic `post_type` argument on a static page
  67. Prevent Duplicate Post Counted by Query
  68. Save queried result into database
  69. sanitize_post() is not sanitizing Post Object
  70. WP Query by variable custom field
  71. WP_Query multiple value not working
  72. Move some posts to end of sort order, even if there is a sort in the wp_Query already
  73. Translating WP query into to SQL query
  74. How to get top rated posts using wp query?
  75. Unusual high query of user meta data
  76. Woocommerce featured products query no longer working
  77. TAG Query showing only 1 result
  78. Tax_Query not working – connecting to second wordpress database
  79. How to search CPTs in draft using get_page_by_title()
  80. WP Query Meta Query
  81. Custom WP_query and integrating into theme file
  82. Empty ‘terms’ in ‘tax_query’ returns an empty array
  83. Archive – Show Page Month Headers
  84. Get newest value of an array
  85. Return a single custom post from multiple meta queries
  86. ordering and optimizing functions
  87. Why does order ASC break offset in WP_Query?
  88. new WP_query using custom fields
  89. Having Trouble Running Query From Shortcode Using Tribe’s Events Plugin
  90. Change ‘post_modify’ with a query
  91. query post based on comparison
  92. Dynamically create array from page title
  93. Ordering Custom WP_Query loop by meta key value with pagination
  94. wp_pagenavi on WP_Query using customfields
  95. paginate_links() on page (shortcode output)
  96. WordPress Query Returning Every Post
  97. shortcode with $atts with strange results
  98. How to include custom fields in wordpress search
  99. Extend search query to search meta keys values based on search string
  100. AJAX multiple search boxes not merging with array merge
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)