Create an array with a string key from wpdb->get_results

Found the solution:

$currentProducts = $wpdb->get_results("SELECT feedid, id, size, price FROM products WHERE shopid = $shopid", OBJECT_K);

The OBJECT_K parameter makes an associative array with feedid as key: https://codex.wordpress.org/Class_Reference/wpdb#SELECT_Generic_Results

Related Posts:

  1. Fetch array with $wpdb
  2. How to fetch an array in $wpdb?
  3. Save data from a checkbox to a wpdb array
  4. PHP | left join avg query give me Array()
  5. Access to numerically indexed array in wpdb Class and undefined offset
  6. Get 3 row ID’s via ARRAY_A
  7. $wpdb->get_results in not an array
  8. Echo only gives me the first part of string
  9. wpdb select from using array as search parameters
  10. wpdb Cannot Access Associative Array Data in a Count Query
  11. How to parse row results from $wpdb -> get_results
  12. Why $wpdb->show_errors() and print_error() is showing an output even if the query output is correct?
  13. $wpdb->insert not working in any way
  14. get_results on large datasets
  15. $wpdb->insert() and Values for Datetime Columns?
  16. Change post status based on meta value
  17. wpdb->insert not working
  18. Speed optimization of $wpdb->get_results
  19. How do I create a single.php for a specific category?
  20. $wpdb is get_results escaped
  21. Using $wpdb generates DB error
  22. How do you use prepare when asking for a list of id’s
  23. How to get top 10 user is based on user meta value
  24. $wpdb Query Result not coming but in phpmyadmin it works [closed]
  25. wpdb prepare: passing varible number of fields as second argument
  26. $wpdb insert array
  27. Wpdb query for comment meta for current post
  28. How to update records using $wpdb?
  29. Join inside a wpdb query.. confused!
  30. Why doesn’t my insert query work?
  31. How to prevent $wpdb->prepare stripping a leading zero in variable value?
  32. Generate a unique hash/number for tracking on $wpdb insert
  33. show badge with count for pending items in custom post type
  34. wpdb->insert and stripslashes against sql injection
  35. create drop down menu in theme customizer from custom db
  36. Are there risks associated with using wp_options table using wpdb to update theme options
  37. $wpdb->insert is running multiple times on page load, but only called once
  38. $wpdb select query by month, post type, and taxonomy term
  39. Get an array of meta_values for a user meta_key
  40. WPDB – How to search a column in a table
  41. Confused by $wpdb->prepare
  42. WordPress (on AWS ubuntu) database Fails “Connection refused in .. /wp-includes/wp-db.php on line 1531”
  43. How to display user_nicename and usermeta values by custom query in WordPress?
  44. How to access PostgreSQL using WPDB?
  45. How can I combine one field using wpdb and group by?
  46. How to get entry by title by using wpdb
  47. $wpdb not being defined in function: Fatal error: Call to a member function query() on a non-object
  48. How to obtain a reference to $table_prefix in $wpdb object
  49. Trying to Connect to different database
  50. WordPress is trimming leading 0s
  51. Why does this WPDB code throw an empty WPDB error? [closed]
  52. wordpress $wpdb works only once
  53. get_results not returning anything
  54. WordPress core code contains things marked as deprecated by… WordPress?
  55. $wpdb – joining shows no result
  56. Compare transient data with a meta box value
  57. How to left join meta in queries [closed]
  58. CREATE TABLE with dbDelta does not create table
  59. WP-PostRatings: list current user’s rated posts
  60. Get unique results from this function
  61. WPDB Join with custom table
  62. Getting values from wpdb
  63. Why is this $wpdb query looping 5 times?
  64. wpdb query not returning results containing single quotes
  65. duplicate entries in database while using save_post or wp_insert_post
  66. WPDB Table Does Not Exist
  67. Unknown column ‘siteurl’ in ‘where clause’ WPDB outside
  68. Inserting a MySQL record into a table with an array of field names and an array of values
  69. Incorrect Use of wpdb::prepare()
  70. Ascending order of yearly archives [closed]
  71. $wpdb->get_results(…) with $wpdb->prepare(…) returns empty array despite correct query
  72. wpdb insert formatting for date in array
  73. how to list all post that are in the custom taxonomy using $wpdb
  74. $wpbd->insert() does not insert user data
  75. Why $wpdb->insert and $wpdb->update not working server but it is working in localhost?
  76. wpdb prepare placeholders for MySQL keywords
  77. Sql query triggered twice
  78. Unable to insert data into using custom plugin
  79. Escaping a WPDB Object in One Shot
  80. Debugging db calls: $wpdb->insert works on test site, not on identical production site
  81. Create a stored procedure on plugin activation
  82. Get last element from wpdb as a string
  83. Creating an Angular factory from custom database table
  84. I am not getting result from php function that is json encoded
  85. Object Cache – Avoid db queries totally
  86. Custom database query to validate data
  87. Creates only one table and not the other
  88. Update all fields of table with ON DUPLICATE KEY UPDATE command
  89. WordPress – wpdb query does not list same result as sql query
  90. What is the best practice to initialise $wpdb by loading wp-load.php?
  91. adding a log row log table, when the draft post publish
  92. How to make iteration on wpdb->update or query statement?
  93. looking for a way to allow users to backup the plugin db data(save as)
  94. Jeditable Plugin working as it should – scope issue?
  95. Out of Memory – Line 791 of WP-DB.php (mysql_real_escape_string)
  96. Site going down due to slow queries
  97. Call to a member function get_results() on a non-object in wordpress plugin
  98. How do I change the datetime format from ( ‘y-m-d’ ) to ( ‘d m y’ ) [closed]
  99. $wpdb The query does not contain the correct number of placeholders
  100. $wpdb:insert, more arguements in $format array than in $data
tech