How to return the values from a row where a value occurs for the first time among the rows available?

So what you want is to use MySQL’s “ORDER BY” feature:

SELECT Treatment FROM my_table WHERE Used=0 ORDER BY Allocation_number ASC LIMIT 1

So you look for all rows where Used=0, order (sort) them by Allocation_number in ascending order, and then pick the first row that matches. (“LIMIT 1”)

I’ll let you plug this into $wpdb as an exercise… 😉

Hope this helps!

Related Posts:

  1. Create a post builder skin in a plugin
  2. Passing a parameter to filter and action functions
  3. Get a list of all registered actions
  4. Preventing a plugin from updating
  5. Customizing subject in comment notification e-mails
  6. Is their any way to Extend WPDB class and Overwrite the Default Query Function
  7. WP showing “warning: call_user_func_array()”, What to do?
  8. Using nextGen Gallery.. how can I call a list of all Gallery Names?
  9. Disallow a user to post in certain categories
  10. Which hook should be used to validate custom form fields on the login form?
  11. Hook (upgrader_process_complete) running moment
  12. Adding a form at the end of the content
  13. How can I add a custom meta value on file upload?
  14. Adding dynamic section to WordPress
  15. why does the add_action(‘the_content’) overwrite my page
  16. Fatal error: Class not found in
  17. woocommerce product attributes
  18. How to filter content post only on save
  19. Filter or action hook to insert content on admin pages before tag
  20. Showing Notifications While Activating Plugin
  21. plugin_action_links_{$plugin_file} hook not in the main plugin file
  22. Woocommerce Shipping module available only for type of products [closed]
  23. WordPress Plugin Boilerplate – add_action hook in static “activate” function
  24. Put code into body tags near top, using a plugin
  25. merging an array to an existing array using add_filter
  26. template_redirect not being called when using ajax
  27. Hook before & after plugin / core update
  28. publish_post plugin hook doesn’t always pass $post->post_content
  29. Plugin custom Action Hook not working
  30. get_plugins() doesn’t work after plugins_loaded
  31. Hook to generate a dynamic sitemap with “All in One SEO Pack” Plugin
  32. add_action in functions.php, do_action in plugin?
  33. How to correctly detect accessing wp-content/uploads?
  34. add action for displaying posts using a shortcode
  35. Randomize attachment IDs
  36. Are there hooks for WordPress updates?
  37. Pass info from functions.php to plugin
  38. Plugin activation hook in an abstract class
  39. Remove rewrite rules generated by plugin during deactivation‎
  40. Change permalink structure hidden button edit
  41. WordPress filter that hook after each action/filter hook
  42. When to use action hooks and plugins
  43. Is there an earlier hook than login_head or login_enqueue_scripts?
  44. Gravity Forms plugin: How to use “gform_editor_js” action hook? [closed]
  45. Using a post-signup hook to get user details
  46. Map a custom id to wordpress post id
  47. Trigger Elementor Popup via code [closed]
  48. Calling plugin function inside custom plugin for onclick event
  49. get current date + 90 days and checking every day
  50. Filtering WooCommerce Orders by Category
  51. How to get post ID with hooks publish_post, new_to_publish, etc
  52. WooCommerce search products between price range using WP_Query
  53. Add sub menu page in your plugin
  54. how to change automatic placing of social plugins below content?
  55. Deactivate JS Script in Plugin Shortcode
  56. Plugin Development – Functions or Hooks?
  57. How to customize a title by passing query string?
  58. Are there action hooks for comments?
  59. Adding Plugin Assets to Header
  60. What are admin hooks
  61. Always get creating a new table with foreign key
  62. How do I add $_SESSION[”] to my wordpress page?
  63. WooCommerce: after install hook
  64. How to use filter to disable adding a product to wishlist?
  65. WordPress: Add custom add_filter for custom functions
  66. Function added to hook “new_to_publish” not executing – custom plugin
  67. How to use apply_filters?
  68. Plugin: Hooking up classes that have their own hooks
  69. How to deactivate my plugin upon deactivation of NextGen
  70. Hook for plugin to insert into entry-meta
  71. Use a hook or filter, or overwrite this Gamipress function?
  72. Hook from plugin doesn’t fire up from external PHP script
  73. How to search post titles with whole words only, but not the exact word only?
  74. Is there a hook similar to “save_post” which only fires AFTER the post is completely published?
  75. Callback hooked to post_updated firing on new posts as well
  76. Randomize post (and page) IDs on generation
  77. save_post hook partly firing in update post
  78. My plugin runs on every single WordPress page, but I want it to run only on activation
  79. The function called on the wp head hook becomes null
  80. front end editor creation for Restropress plug in – displaying information from a WP admin area, on a different URL
  81. Show post object of any page in frontend
  82. Use action, filter, or hook to append HTML to WordPress plugin function
  83. Passing function into add_action always returns the first argument
  84. Hook to display element as product on category page
  85. Is it possible to disable a theme programmatically?
  86. Hook on widget context plugin to add custom context for widget
  87. plugin not hooking to my custom hook
  88. wp_login_form() ignoring login_form action hook
  89. Modify a plugin’s content
  90. How should I use a plugin function as a hook?
  91. Plugin hook breaks new WP 4.0 media library grid view?
  92. Proper way to trigger a MySQL query via link in a plugin
  93. WP-Snap too slow (caused by WP_Query?)
  94. Variable scope in plugin outside loop [closed]
  95. Checking url from plugin [duplicate]
  96. User register hook can’t access form request
  97. WordPress Hooks : Where to place callbacks that repetitively yield the same effect?
  98. How to Add Extra Text In WordPress Title Before Post Publish
  99. Why is my activator class adding the files/running the actions I add?
  100. Admin Notice is only localized when displaying the “Plugins” Backend Page
techhipbettruvabetnorabahisbahis forumutaraftarium24edueduseduseduseduseduseduseduedusedus