Get posts having meta value between two numbers

Your question isn’t clear, but I’m making the following assumptions:

  1. The user is submitting $_POST['search_option_money'];
  2. You want to return all mycredit posts where $_POST['search_option_money']; is between the offer_money_start and offer_money_end custom fields.

The problem is that you’re misusing the key and value arguments of the meta query. The key is the name of the custom field, and value is the value you’re searching for.

Also, the BETWEEN meta query is when you want to find posts based on a meta key’s value being between 2 specified values, not for finding posts based on a value between 2 separate meta keys.

If you want to find posts where a given value is between the value of 2 separate meta keys, you need 2 separate meta queries:

$query_args = [
    'post_type'      => 'mycredit',
    'posts_per_page' => -1
    'orderby'        => 'rand',
];

if ( isset( $_POST['search_option_money'] ) ) {
    $money_form = $_POST['search_option_money'];

    $query_args['meta_query'] = [
        'relation' => 'AND',
        [
            'key'     => 'offer_money_start',
            'value'   => $money_form,
            'compare' => '>=',
            'type'    => 'DECIMAL',
        ],
        [
            'key'     => 'offer_money_end',
            'value'   => $money_form,
            'compare' => '<=',
            'type'    => 'DECIMAL',
        ],
    ]
}

$my_query = new WP_Query( $query_args );

This will query any posts where the submitted value from the form is greater than the offer_money_start custom field, but less than the offer_money_end custom field.

I’ve also formatted the code so that the meta query is properly set only when $_POST['search_option_money'] exists. Your current code will assign meta_query to an undefined variable if it doesn’t.

Lastly, POST requests are inappropriate for getting data, which is what searching or filtering is doing. Your form should be use the GET method, and $_POST should be $_GET.

Related Posts:

  1. meta_query with meta values as serialize arrays
  2. Use REGEXP in WP_Query meta_query key
  3. compare meta_query in get_posts arguments
  4. Display products from specific category in shop page
  5. How to Compare Two Meta Fields
  6. Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
  7. Getting attachments by meta value
  8. Order by meta_value_num DESC and meta_value ASC on WP 4.0
  9. Query by meta_key and order by meta_value_num return orderby date
  10. WP_Query not working as expected for attachments and custom meta_query
  11. WooCommerce: filter by parent product’s taxonomy and product variation’s meta data
  12. Wp_query order by multiple custom fields?
  13. WordPress altering my custom query, How to fix it?
  14. How to query ‘posts_per_page’ to display a different blog posts index template?
  15. Order by meta_key in custom post type doesn’t affect the query
  16. How to create/modfiy WP_Query to search in post title OR custom field?
  17. Order By Multiple Meta Fields
  18. Advanced WP Query hogs the SQL server
  19. How to get user_id from wordpress database inside ajax function?
  20. Multiple meta queries but arrange by specific meta value order
  21. Order Posts by meta value AND published date
  22. WP_Query with multiple meta fields filter?
  23. How to combine meta_query and post__in in WP_Query
  24. What format does the meta_query TIME type require?
  25. How to orderby meta_value_num with dollar ($) sign
  26. pre_get_posts order by not working
  27. WP_Query filter and order by meta ordering by wrong joined table
  28. WP_Query last five posts, simply ordered by meta_value
  29. Meta Query Array Error 500
  30. What is the random string I am seeing when I use get_query_var?
  31. Fetch Record based on meta key dates
  32. meta_query in WP_Query value is not accepting array
  33. Changing sort order for presentation by Jetpack infinite scroll
  34. meta_query not working as expected
  35. get posts by meta_key from inside key of post meta
  36. Help optimizing slow WP_Query with meta_query
  37. meta_value_num not ordering all items
  38. Meta Queries – should nesting work after WP 4.1?
  39. Filter and Order by Multiple Custom Meta Values
  40. Meta Query relation “AND” then set array accordingly
  41. 2 weeks ago from meta query meta value
  42. Query posts with “non set” meta value
  43. Query with meta_query and tax_query together not working properly
  44. Array as ‘key’ in WP_Query
  45. Is it possible to query a custom field where the value is between two fields?
  46. Filter posts by comparing custom meta value against postdate
  47. Wp_query with 2 meta keys and array of meta values
  48. meta_query: check if number exists
  49. Searching for meta_key returns 0 posts
  50. Event with multiple dates, display events chronologically
  51. meta_query fails to compare on values containing apostrophes
  52. Check if searched number is within the post meta value
  53. add_query_arg to compare and display events from a certain date
  54. WP Query / Meta Query [duplicate]
  55. Query posts by searching for a string in a meta field
  56. WP_Query not returning correct result with meta_query parameter
  57. Query multiple post types, but different order for each
  58. How to add date_query to meta_query array
  59. Order by the first array within a meta_query
  60. Query ACF relationship field – Comparator IN – Value array
  61. Query on meta values and post title
  62. Combine query in WP_User_Query()
  63. Multiple nested meta queries
  64. How to _GET multiple value checkbox WP_Query in Custom Toxonomy / Custom Fields
  65. How do i create a custom post query when the meta value is an array?
  66. How can I modify the query by adding to the existing query?
  67. Custom Meta Query doesn’t work the same on two site
  68. WP Query – grouping posts by same meta key, adding together values from another key
  69. How to do WP_User_Query for Nested Array value Inside Nested Array field
  70. Query for current post
  71. WordPress Query custom ordering by temporary variable
  72. Custom query to retrieve oldest post and retrieve others with date interval
  73. Comparing Meta Field date in WPQuery using Meta_Query?
  74. How to create better WP_Query to look for date time which is anywhere between two meta values?
  75. Very slow query generated getting meta data from posts
  76. Order by Date Custom Field
  77. Filtering WP_Query based on wp_postmeta keys values
  78. WP Query. Ordering posts by another post types meta
  79. Complex Meta Query
  80. Multiple meta_query not working
  81. compare for multiple meta values for same key in wp_query
  82. datetime picker, timestamps and meta queries
  83. WP_Query with meta_query won’t orderby
  84. meta_query only check if both value are set
  85. Get posts meta_query by repater field
  86. Query 3 meta_key and orderby
  87. wp_query sorting – one specific meta_key value at last and then sort by create date
  88. Extending WP Query: Custom geolocation meta values work, but tax_query breaks
  89. meta_query not working with the_content()
  90. Using custom field as ‘orderby’ value causing post grouping by publish date
  91. Get closest event where meta_key field is an array
  92. Set right order for query that returns posts based on two custom fields
  93. Meta_query weird behaviour
  94. Looking for a way to exclude frontpage and nav menu from query filter
  95. Creating Custom Query
  96. Get posts by meta value except one post [closed]
  97. WP_Query by meta key not returning any posts
  98. How do I have multiple metaqueries inside one wordpress query
  99. WP query with multiple custom meta not respecting orderby
  100. Display only posts with thumbnails