Wpdb get->results to out the the month from the db

You could use the MONTHNAME(dato) on your select Like

$rows = $wpdb->get_results( "SELECT MONTHNAME(dato) as month_name, avg(fiske_vaegt) as fiske_vaegt 
    FROM `wp_registreringer`
    WHERE MONTH(dato) = 11 AND YEAR(dato) = 2017;");

and access it like this echo $row->month_name

Related Posts:

  1. How to Generate a list of Most Commented post?
  2. How to return number of found rows from SELECT query
  3. $wpdb->delete column values IN ARRAY()?
  4. WPDB: how to get the value of a field in a custom database table
  5. $wpdb->flush(); breaks the loop
  6. Any possible way to make $wpdb->get_results() return anything else than array?
  7. database interactions using OOP
  8. Trying to establish connection to External Database
  9. Getting id of poll from WP database
  10. How to insert a single row to WP database table?
  11. $wpdb->update with multiple parameters gives error
  12. Update results, Before deleting the related category [closed]
  13. How WordPress reacts to a lack of memory of the server [closed]
  14. How to retrieve the data from the sever and displaying it in a page?
  15. I can’t update my data through $wpdb
  16. wpdb Cannot Update column in Database
  17. Delete database record using plugin from admin panel
  18. WPDB – Read and write value from / to database
  19. Add row to custom database Table and delete all rows older than 1 day
  20. select a single val though a table in wordpress
  21. Add posts to custom table in database instead of wp_posts
  22. Using wpdb to connect to a different database is not working
  23. How to grab data from input and store it into custom table in database?
  24. Accessing external database: ERR_INCOMPLETE_CHUNKED_ENCODING
  25. How to fetch results from database
  26. Querying multiple meta_keys in WordPress SQL query
  27. MySQL database migration to WordPress
  28. Fetching wpdb data from a php file seems to break?
  29. Insert into db with foreach problem
  30. How to get data (not value or name) from radio options to POST to database
  31. Putting form result in my database
  32. How to export/import theme customizer settings?
  33. WP API V2 returning Invalid User ID
  34. Print out WordPress user ID – two sites with same code but different output
  35. Store loop into array
  36. Looping through WP_Post Object
  37. Access/update database with jQuery
  38. Show Custom Taxonomy Title
  39. How to exclude specific category from the get_the_category(); array
  40. spliting posts into two columns
  41. Add custom php database code above
  42. How to Display a Single Post Excerpt
  43. Show MySQL errors that occur when I excute $wpdb->insert()
  44. how to delete 30 day old data using PHP [closed]
  45. Echo a hierarchical list of post data from custom fields
  46. Changing layout with wp_customise
  47. WordPress not reflecting changed of the database
  48. Querying wpdb using PHP
  49. wpdb php get_var query to get ID for URL image doesn’t work for ID over 999
  50. Database query works fine outside WordPress
  51. How Can I use WP_Query to Only Display 1 Post from Custom Post Type if Query Returns Posts with Matching ID in Custom Field
  52. Help with a $wpdb MySQL Query
  53. db converts decimal number wrong
  54. I’m trying to create an array with a foreach loop, but the array only stores the last item [closed]
  55. $wpdb returns duplicate posts
  56. Creating Database Table vs. Adding MetaData to Post & User
  57. Cant connect to database with php 7.3
  58. Problem with custom loop and wp_list_pluck [closed]
  59. Display child page content of a specific parent on home page
  60. Creating custom page template from existing PHP site
  61. wordpress site – using custom database and PHP
  62. How to use AJAX in WordPress in MYSQL query?
  63. How to wrap every 3 posts in a div (and close the last div too) [closed]
  64. Dividing the loop to style post differently
  65. WordPress loop is not working
  66. Fetching review value using wpdb class
  67. Problem in replacing the_content with the_excerpt()
  68. Search AJAX Filters – Multiple Query Loops Into One Loop (Optimization)
  69. MySQL Query Returns Array () In Shortcode
  70. Passing in MySQL prepare statement parameter separately throwing error
  71. Database SQL query error
  72. Change wordpress’ database data using ajax – how to get current user id?
  73. Pagination contents not changing in Front page WordPress
  74. MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
  75. Display all categories including sub categories under a list ul
  76. Retrieving and Displaying Data From a Table
  77. Where does php code to load data go?
  78. Adding new divs with custom classes to products on WooCommerce shop page [closed]
  79. Can I disable auto increment of WordPress Posts Database to utilize previously deleted records?
  80. Latest posts feed with a specific post always first
  81. Updating the database after parsing CSV document
  82. problem in using wpdb->prepare and a string placeholder
  83. How fix error in the WordPress loop?
  84. Advanced WordPress SQL Query
  85. Efficient way of querying for a “fallback” post?
  86. Issue in url update when using wordpress update query
  87. Loop 1 user randomly
  88. Create a hierarchical loop at predefined markup requirements
  89. MySQL query in WordPress with AJAX
  90. enumerating custom taxonomies?
  91. Order by in foreach
  92. How to display thumbnail if post is assigned one otherwise not
  93. Pagenav Not appearing on custom Template
  94. Adding if statement to content for homepage
  95. Tables not showing divs and loop/php items
  96. Pagination in category.php not functioning
  97. How to handle parent and child pages?
  98. How to create a loop that will display one post and stop?
  99. save array of objects with update_option
  100. WordPress / PHP: Check if column has value and then check if value in array