greatest() function returns undefined property

I think you want to use get_var(), not get_row() – looking at the documentation, MySQL’s GREATEST just returns a single value.

$results will then just be the value of the greatest (be it up or down).

If you want the greatest up and the greatest down, use;

$wpdb->get_row("SELECT GREATEST(up) AS 'up', GREATEST(down) AS 'down' ...")

Related Posts:

  1. How to properly insert data into custom table via plugin
  2. How does WordPress handle MySQL row lock errors?
  3. Can I explicitly specify ENGINE=InnoDB in WordPress?
  4. Bad Request (Invalid Hostname) on working server, database problem
  5. Changing BIGINT to INT
  6. How to write one comment and publish on every post using database or plugin?
  7. How to determine what is generating large amount of database queries?
  8. Help With MySQL to WPDB Query Conversion
  9. get current date + 90 days and checking every day
  10. How can I perform high-level database merging for WordPress within continues delivery?
  11. WordPress Backend HA (Automatic failover)
  12. Automatic switch to backup database on fail
  13. Migrating to WordPress Recipe Plugin and Some SQL Issues
  14. Multiple instance of data in plugin custom database table on plugin activation
  15. Better ads plugin has 500.000 entries in wp_postmeta
  16. after wordpress update to 3.5+ i get many errors in plugin wpdb::prepare()
  17. Cannot get wpdb data (Error in a simple fuction) [closed]
  18. How to keep variable `$post` to using in another file
  19. dbDelta not adding additional columns in plugin database update
  20. Always get creating a new table with foreign key
  21. How to do database for download stats?
  22. How can I fetch data from another website to my wordpress website with mysql database
  23. DB Query not working in Plugin
  24. External wpdb connections in different plugins on single page
  25. WordPress plugin: efficient way to store large data
  26. WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
  27. How can i listing current category and Featured Category post list?
  28. Integrating Custom Database with WordPress
  29. How to display results from a data table with an encrypted user id?
  30. add_action for publish_post doesn’t work
  31. What database state changes happen after a post is manually “updated” with no changes?
  32. WP Function does not trigger on Webhook API Call
  33. Cant create table on plugin activation
  34. Performing CRUD operations on front end in wordpress
  35. How to add specific script to WordPress webpage that will working with user input and databases
  36. Get Shortcode output to database for static post_content
  37. Store GravityForm data in phpmyadmin (mysql)
  38. Moving a few select DB tables to a new WP instance
  39. WordPress database problem wp_posts, primary key
  40. HyperDB failover Delay
  41. how to repeat taxonomy in different places on wordpress
  42. Write mysql credentials in plugin
  43. How can I delete the options from DB when the plugin is deleted?
  44. PHP Creating a formula from mysql db values and db stored math operator
  45. Remove posts that start with similar words (like a delete duplicate posts plugin)
  46. Import posts from a different database with the same old id
  47. Cannot login to ADMIN even after changing password in phpmyadmin
  48. How to get number of Affected rows from wordpress dbDelta() function
  49. Unable to create new database table upon plugin activation using dbDelta
  50. Redeclare theme’s function in a plugin
  51. How to add class in plugin only for network site?
  52. Where to hook my plugin’s action
  53. Pass info from functions.php to plugin
  54. How does WordPress process plugin installations?
  55. Embed a Google Sheet as you view it in a separate tab?
  56. I have functions in my wordpress plugin. How do I get them to work for me?
  57. WordPress Plugin Page is Loading in Admin Content Container Instead of Separate Page
  58. Get post by ASC from custome field DATE picker
  59. How to create TEMPORARY Download links in a wordpress POST?
  60. Building an email signup form. Where should the information be saved in the DB?
  61. Conditionally add apt. Open Graph meta data to different pages on WordPress site
  62. PHP Fatal error: Call to undefined function plugin_basename
  63. Saving Custom Post types and fields to a custom table
  64. Retrieving a Value from a wp-database
  65. plugin development: problem with functions
  66. Need help restoring my WordPress blog
  67. MySql database help for a plugin
  68. add_query_arg not working
  69. WP plugins for building a database?
  70. Shortcode button dosent work for all posts. Work for first post only
  71. How to remove Database Table in WordPress via Function file?
  72. mysqli_error() expects parameter 1 to be mysqli, null given in own db class
  73. Where does WordPress store plugin (enabled/disabled) status for multisite?
  74. Is there a way I can find wordpress posts that don’t contain a word?
  75. Bulk edit existing shortcode within custom field
  76. Prevent shortcode from being wrapped in tags
  77. AJAX button run function
  78. Dropdown menu on custom page with product to choose number of products per page
  79. Change wordpress current_time function to different timezone
  80. Inserting HTML tag with ACF into shortcode
  81. When to use action hooks and plugins
  82. Executing my function once on a specific time
  83. Display data on Word Press site posts and pages from mysql table
  84. Plugin Options Not Saving to Database in WP 4.5
  85. How to append to title via functions.php for auto-posting plugin [duplicate]
  86. How to stop or remove an action being called inside a function of an extended class
  87. Call to a member function have_posts() on a non-object on normal loop
  88. Missing Argument
  89. load_plugin_textdomain error
  90. How to override a plugin function wrapped in a class?
  91. Bootstrap Drop Down menu is not working
  92. How to Display a Plugin function (content) on frontpage using index.php
  93. Doubt using $wpbd->get_col for a single column
  94. Access WordPress database outside of WordPress
  95. How to create custom tables in WordPress using my own plugin?
  96. wordpress plugin is not activating from widget
  97. How to access data in wordpress database externally using php
  98. Theme my Login plugin, how to update fields
  99. Is it possible to create Custom Post plug-in?
  100. Edit Yoast SEO breadcrumbs output [closed]
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)