Prevent duplicating specific column from database table

This is more of a general PHP question than a WordPress one.

Use an array with the county as a key to group up your results.

$groups = array();
foreach( $results as $result ) {
    $groups[$result->county][] = $result;
}

var_dump or print_r on $groups to see how this groups up your results.

You can then loop over $groups, if there’s only one item in a group you output a single option, when there’s more than one then you make an option group.

Related Posts:

  1. Generating dynamic Tabs with multiple query post loop
  2. Duplicate posts in paginated results
  3. Avoid WP_Query’s duplicate posts with taxonomies
  4. Duplicate posts on archive page
  5. How do I get the attributes of a short code from a post?
  6. Show scheduled posts in archive page
  7. post__in – Placing content from a foreach loop inside of an array
  8. loop query exclude meta_key with meta_value
  9. “Blog pages show at most” in The Loop
  10. wp_insert_posts Fatal error: Maximum function nesting level of ‘100’ reached, aborting!
  11. Post Loop not Returning Permalink
  12. Custom page template
  13. Get posts that matches specific terms of multiple custom taxonomies
  14. add_filter() doesn’t work in loop
  15. The Loop in Static Page
  16. Content/Excerpt length control for a specific loop?
  17. Why we use if with while loop?
  18. Loop posts only excluding first post
  19. Loop repeating design pattern
  20. Customize WooCommerce Product Images (Placement and size) [closed]
  21. Create a loop that gets pages with their template
  22. Why is my loop not dynamically grabbing the correct Category and displaying all categorized posts?
  23. get latest 5 posts and a specific post and sort in a specific order
  24. How to check if a post exist?
  25. Query posts if meta key starts with
  26. 3 Posts in Loop, Show Stickies First
  27. Loop within a loop (Again) for template
  28. Why cant you place the Loop outside of the index.php?
  29. sticky post in custom loop
  30. Rating system and changing the loop
  31. Ajax Button to load more Posts into a timeline
  32. How to target thumbnails of the first post in the loop
  33. On single.php, fetch 2 posts created after and 2 posts created before in relation to the actual post (using menu_order)
  34. Problem getting current post tags to show in a widget
  35. Post classes in the loop are being changed in certain themes
  36. Exclude page name from loop
  37. PHP if post is already displayed, then
  38. How to style first post differently with ‘get_template_part’?
  39. Include multiple page ids in loop
  40. in Foreach Loop the Description is not showing?
  41. 404 Template customization | Want 10 recent Post on the 404.php error page apart from the error Notice
  42. How to append a query string to pagination?
  43. For each loop on every word in post
  44. Display name of taxonomy once
  45. Use have_comments() for current post instead of last post in loop
  46. Displaying the first, second, and third posts from a category in separate slides
  47. Sending mail not working correctly
  48. WordPress shortcode in content, output in sidebar?
  49. Using variable in WordPress loop as criteria
  50. WordPress Alphabetical Sort Loop Issue
  51. Get_template_part() problem with the_content()
  52. Altering “posts_per_page” for defaut loop
  53. Why doesn’t ‘continue’ work in page?
  54. Fetching posts from wordpress function in ajax
  55. Saving return value from the_author_posts_link()
  56. how to run loop in function.php that sends email based on specific conditions?
  57. How to use this $tax_selection variable in this custom loop?
  58. loop inside a loop : search for posts in the same category
  59. How to sort a loop after most viewed
  60. How to declare a variable in a loop and make it available in the template file
  61. WordPress posts loop not displaying all posts on blog
  62. get_page_by_title not working inside fucntions.php
  63. Bootstrap tabs are not being clicked in WordPress loop
  64. Get gallery in loop through ajax
  65. Get a specific size from wp_get_attachment_image_src
  66. Pagination on a underscore custom theme
  67. WordPress + Isotope: how to give different widths to each entry?
  68. hide woocommerce tab if empty
  69. Get top Page IDs from menu and cycle through their child pages on a scroller
  70. Show other category posts in single.php
  71. Why does it loop twice?
  72. Cant pull in featured Image
  73. Custom Looping of WordPress Posts
  74. how to place Post and page content side by side
  75. Add specific class to featured posts
  76. Echo Most Recent Sticky Post in Loop?
  77. Link Button url count php and wordpress
  78. ACF field not appearing correctly in loop
  79. Posts are being displayed from old to new, in ascending order
  80. Loop in taxonomy for terms and post
  81. WordPress Tags in class
  82. Using shortcode within shortcode with dynamic variable
  83. modify default HAVE_POSTS() Loop without inserting new variable (i.e. $loop->HAVE_POSTS)
  84. Display articles related to a custom field on a page
  85. The Loop isn’t working
  86. Changing the loop w/o killing category links
  87. Custom loop page with post navigation
  88. Pages with a loop (index, archive) are loading the first image as post_thumbnail
  89. the loop – how to control whether wp or plug-in runs it
  90. stuck with template hierarchy
  91. An action that runs after each post in the loop on index/archive page?
  92. Modify my code – which takes the first sentence of the post and use it as a h2 tag – to work outside the loop
  93. How to show only specific tag in wordpress loop
  94. Different style for first two (sticky) posts
  95. WooCommerce – Checkout suddenly stops working [closed]
  96. Want to images load first then title in WordPress loop
  97. How to add a continuous number to HTML tag attribute value inside The Loop [closed]
  98. WordPress Not Sorting By Custom Field
  99. wp_mail function not working in user query loop
  100. How to set and retrieve cookies while in the loop