wordpress ajax relationship query

Look at the very last part of that query– LIKE '%\"17497\"%'. You are searching for any characters, followed by literally "17497", followed by any characters. I am pretty sure that is not what you want. I think you want any characters, followed by 17497 without the quotes, followed by any characters.

That means the meta_query is written incorrectly.

$meta_query = array(
    'key'       => 'lineup_artists',
    'value'     => $ArtistID,
    'compare'   => 'LIKE'
);

You don’t want to be adding your own quotes like that.

You also want to be checking that $ArtistID has a value before trying to use it, and you should be doing some data sanitization and validation before using information in $_POST. $_POST data is not safe data.

Related Posts:

  1. Using OR conditions in meta_query for query_posts argument
  2. How To Fix WP Query Returns Results But Shouldn’t?
  3. Include post content of linked posts in search
  4. Slow wp_posts and wp_postmeta query using Advance Custom Fields
  5. WP_Query with “post_title LIKE ‘something%'”?
  6. Pagination with custom SQL query
  7. Display List Of Posts Containing a Relationship Field Value [ACF]
  8. Whats the difference between post_limits and pre_get_posts?
  9. ACF Relationship Field Search Filtering [closed]
  10. Is it possible to wrap Geo Location search around WP_Query?
  11. Is it possible to select against a post’s parent’s fields with WP_Query?
  12. Extending WP_Query — Optimise SQL query
  13. ACF datepicker meta_query Compare Dates in m/d/Y g:i a – Not in Ymd Format
  14. How to filter sql only for a specific post type
  15. How to make an activities stream mixing posts and comments?
  16. SQL Statement generated by WP_Query not producing expected results
  17. WordPress meta_query and order by custom field
  18. What is an efficient way to query based on post_meta?
  19. SQL query equivalent to WP User Query
  20. Revolution Slider Orderby Two Custom Fields
  21. Recommended way to drop a pending query (in pre_get_posts)?
  22. how to retrieve specific product attribute value in an sql query?
  23. meta_query with array as value
  24. query posts in functions.php and update a field
  25. Filter WordPress posts by between parameter
  26. SQL User Query by Multiple Roles using PHP
  27. Advanced WP Query hogs the SQL server
  28. SELECT * FROM $wpdb->posts WHERE ID > 160
  29. Minimising number of queries on a page when using Advanced Custom Fields
  30. Query Posts depends on custom field inside repeater field using acf
  31. How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
  32. ACF Relationship + WP Template Parts
  33. Query post with meta_query where date is not in future
  34. Minimising Database Queries when using Advanced Custom Fields
  35. ACF – Get lowest & highest value from field
  36. WP User Query get all authors with last name starting with specific letter
  37. Select from wp_post and multiple meta_value from wp_postmeta
  38. If two first numbers exist in wp_meta_query value
  39. WP_Query meta_query >= date
  40. How to correctly pass values to wpdb->prepare()?
  41. Sort users by “birthday” using WP_User_Query
  42. $wpdb select date range of posts
  43. ACF Date Based wp_query
  44. Multiple taxonomy And acf filter group by
  45. List of the years with posts presented
  46. Custom query based on meta key – Reduce three states to two in results?
  47. Include custom field in Ajax search WordPress
  48. What is the random string I am seeing when I use get_query_var?
  49. SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
  50. Slow WP_Query for custom post type
  51. Complex WP SQL Query
  52. Any number in meta key (wp query)
  53. Query that loads a custom type AND posts whose ids are not inside those custom types custom fields
  54. How do I run through a WordPress loop called from a filter function?
  55. Optional Meta Query
  56. Sorting events by descending date, and ascending time if multiple events on a date
  57. How can I display a custom field from all posts and order them individually from their parent post
  58. Editing the default wordpress search
  59. WP Query related posts by tags
  60. Order by summing multiple values
  61. Is there a way to work with a specific the_field from an already queried post? [closed]
  62. How to Union two different conditions in one WP_Query
  63. How to extract specific post
  64. Woocommerce – Changing the order of the upsell products [closed]
  65. Changing sort order for presentation by Jetpack infinite scroll
  66. Excluding pages in WP_query using ACF
  67. How to do a wp_query with two acf-fields, sorting on one of them
  68. Using Advanced Custom Field for file upload, how do I load the file url
  69. Include data from custom table in WP_Query
  70. Multisite wp_query & switch_to_blog issue
  71. Stuck in the query loop
  72. Get all fields inlcuding “ACF” (Advanced Custom Fields) columns in wp_query
  73. WP_Query with meta_query dosen’t return results
  74. Is there a better way to pull in custom content without querying posts?
  75. How to pass orderby params to $wpdb->prepare()?
  76. Debugging wp_query orderby for taxonomy
  77. Is it possible to query from external database? [duplicate]
  78. WP User Query with Custom Fields and Search Results
  79. Make a SQL query with wpdb in WordPress
  80. Getting additional columns from sql
  81. ACF accessing a field from the query, but not in post
  82. List of ways to access WordPress database?
  83. filter wp_query result with custom field values
  84. How to make posts unqueryable/unpublish posts where ACF relationship field is an unpublished post? [closed]
  85. Merge 2 custom post type posts and taxonomy terms and sort ascending
  86. Add ACF field in a query
  87. Getting rid of unwanted nonSQL syntax characters when debugging a query
  88. How I can change the condition or compare operator for WP_Query in pre_get_posts
  89. JSON – Create rest api endpoint for Advanced Custom Fields
  90. Query where ANDing slug values not working
  91. Slow Query On Search
  92. WP_Query: apply an SQL function to meta fileld value
  93. Expecting statement error from php loop using ACF plugin
  94. Custom query filter by ACF date custom field
  95. Get a list of ACF Repeater-Fields as array
  96. WordPress dynamic AJAX query
  97. How to avoid filling up an array each time I run a WP_query?
  98. How to SQL query posts IDs by categories AND authors?
  99. Randomly select one of last 3 posts
  100. WP Query orderby ACF boolean values and ACF field value
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)