Using $wpdb object in a widget

If you really just want a single row, use $wpdb->get_row($sql) instead.

But your query looks funny…it looks like you’re trying to get the latest ‘client status’ for the user in which case your query should be:
'SELECT status FROM Clients WHERE UserID = '.$current_user->ID.' ORDER BY ID DESC LIMIT 1'.

And if you do that, you can then even use $status = $wpdb->get_var($sql);.

Lastly…did you consider using add_user_meta/get_user_meta instead? There’s a lot of benefits to using the native tables and functions, such as that the records get cleaned up when you delete the user and the likes.

Related Posts:

  1. Should I use wpdb prepare?
  2. Adding Widget form fields dynamically
  3. What is the correct way to build a widget using OOP
  4. $wpdb->insert_id
  5. Widget development – Drop down options won’t save
  6. Calling the widget id of a mult-instance widget from inside the widget?
  7. Is There A Hook To Process The Content Of The Text Widget?
  8. Add content to widget title in admin area within the widget?
  9. Has anyone managed to integrate the wp_editor inside a widget?
  10. Retrieving custom fields with $wpdb->get_results
  11. Edit the output of wp_widget_rss_output()
  12. Script to remove all inactive widgets?
  13. Possible to preset a widget’s contents via a plugin script?
  14. How to add multiple copies of a widget from “available widgets”
  15. Install widget on plugin activation
  16. Really simple query giving error in SQL syntax
  17. Custom Plugin Database relations
  18. why creating tables using $wpdb is not being executed while installing plugins?
  19. How to use mysql IN statement with wpdb update method?
  20. WordPress select dropdown list in widget
  21. Is there a need to do apply_filter(‘widget_title’, $instance[‘title’]) or any other ‘widget_xxx’ filters?
  22. Activation hook not creating table
  23. Dynamic content in a widget
  24. How to pass custom options from widget form to widget update callback?
  25. Broken markup when using the_excerpt() in a widget?
  26. Tips for targeting widget dragable for WP Pointer on widgets.php page
  27. How to create custom field in worpdress default widgets?
  28. Widget Admin – Form Submit Event?
  29. $wpdb -> Batch insert from XML File?
  30. Can I individually style items in the backend widget list?
  31. How to Download and install plugin database remotely
  32. Sidebar widget to show popular post not working?
  33. Widget update function not saving values
  34. Add custom element ID depending where the widget place is, sidebar or footer
  35. Customizer: widget-synced triggers twice
  36. How to insert data to a database table when the field is not yet created?
  37. Where to store the name of a custom table?
  38. include wp-blog-header not working on MAMP
  39. Add a class to a dynamic sidebar’s wrapper
  40. creating custom function to log actions in plugin
  41. Widget is to be compatible with all themes
  42. Issue regarding $wpdb->prepare()
  43. Error on inserting a form value to database
  44. How to create database table, add data, update and delete using wpdb via plugins?
  45. how to search users by ajax live search
  46. Adding custom end points, No error line
  47. Widget Dropdown doesn’t working
  48. How do I get the sub categories of the parent when in a sub category?
  49. How to limit number of number of categories displayed by categories widget
  50. Get draggable widgets on Edit Post page
  51. Dynamically creating classes for Widget API
  52. Why does my widget break other widgets?
  53. CSS not affecting widget output
  54. Using a multiple element in widget form
  55. $wpdb->prepare with LIKE and sprintf
  56. How to optimize multiple insert into wordpress database
  57. Create Widget or Enable Shortcodes in Sidebar
  58. Minimum Widget Width for Plugin Development
  59. $wpdb->update() always need a second try
  60. How to create a wordpress widget that dynamically changes according to the page
  61. Proper Prepare Statement for ALTER TABLE and using AFTER
  62. How to avoid conflicts with db.php / $wpdb and other plugins that decide to use them?
  63. $wpdb in php 5.5
  64. WordPress dynamic widget by location?
  65. Plugin to create Posts and Forums then choose category and parent forum
  66. $wpdb->update Issue
  67. How to relate the Category to user?
  68. Widget internal hooks and functions
  69. WordPress database error: [Query was empty] – using $wpdb->prepare()
  70. My plugin creates custom widgets, How can I programatically add them to existing sidebar widget areas?
  71. How to show multiple instances of the WP125 Widget?
  72. Console errors in 6.0-RC1 Widget screen
  73. How to display specific data from a custom table to logged in users with a custom role
  74. $wpbd->insert_id is returning null
  75. Error code when migrate
  76. How to store sensitive user data (passwords)
  77. How to get inserted row IDs for bulk/batch insert with wpdb query?
  78. Quick Draft widget (dashboard.php) using custom post_type
  79. WordPress Query doesn’t return the correct value
  80. Uncaught Error: Call to undefined function wp_get_current_user() in
  81. Load script on frontend from widget plugin
  82. Can’t get wpColorPicker to work in a widget
  83. If user is logged-in display/hide widgets ( siteorigine) [closed]
  84. User avatar-ACF fields
  85. bindParam? WordPress 4.9.5 SQL LIKE statement %s and %LIKE%
  86. Update database record in plugin
  87. How to embed or integrated a custom WordPress Widget into the theme?
  88. Dedicated server and WPDB Class : huge slow-down of the website
  89. How to implement pagination into a wpdb->result query?
  90. Widget won’t be activated
  91. $wpdb how can i save my postmeta table before querying it
  92. Downloading Generated XML File
  93. wp_register_sidebar_widget in loop within a plugin?
  94. grouping my widgets wordpress
  95. Get fields of a widget
  96. WordPress plugin tables become corrupt
  97. How do I create Widget within plugin that uses its own class?
  98. Nothing happens on WordPress Update command
  99. How to specify widget order or css name via script?
  100. Fixing plugin for wpdb::prepare