Why is an empty result an error? ( $wpdb->get_row )

There isn’t an error. The square brackets are empty– aka “no error”. Put a spurious comma in the SQL and you will see what I mean.

But your SQL is wildly complicated for you are doing. That is entirely equivalent to 

SELECT * FROM $table ORDER BY id DESC LIMIT 1

Though, I notice you are using id rather than ID and I don’t remember any Core tables using the lowercase version. If this is meant for a Core table that will be a problem.

Related Posts:

  1. wpdb get_row database query inquiry
  2. get_row returns empty when data exists
  3. wpdb->insert: do I need to prepare against SQL injection?
  4. How to use $wpdb to delete in a custom table
  5. WPDB prepare – like % – placeholders?
  6. $wpdb->update multiple rows, like IN in normal SQL
  7. Matching database content types to PHP types
  8. Avoiding “Usage of a direct database call is discouraged”
  9. dbDelta does not create Table, but returns success
  10. Saving custom form data into database
  11. wp-content/db.php : where is this file?
  12. Quotes in table name
  13. $wpdb->get_results() returns good result only in first foreach iteration
  14. $wpdb->insert – inserting multiple rows
  15. $wpdb prepared with search term
  16. WPDB->insert with special characters
  17. How Can I Use $wpdb in PayPal IPN file?
  18. Is there a (better) way to access $wpdb results?
  19. Set media metadata (i.e. “dimensions” field) on SVG file after extracting it with a filter
  20. $wpdb->prepare not working with update table prefix
  21. How to use prepare to query with variables
  22. Use $wpdb in wordpress theme files
  23. $wpdb not returning data
  24. WPDB update row with != in where clause
  25. wpdb->get_row() / get_results – is it possible to return an object instances of my own class?
  26. Problem in creating table through plugin code
  27. I want to update my postcontent with $wpdb
  28. How to email user after inserting the username in database in WordPress
  29. Create an array with a string key from wpdb->get_results
  30. How to fetch an array in $wpdb?
  31. $wpdb – do you have to use foreach even if there will always only be one result?
  32. Replicating the WP_Query ‘s’ param with $wpdb
  33. Need help writing a $wpdb query
  34. get the number of queries made on a page(inside my plugin)
  35. $wpdb->insert query changes to SHOW COLUMNS query Output
  36. Fixing wpdb->get_results and wpdb->prepare?
  37. How does the WXR file differ from the WPDB?
  38. Rolling Back from current WordPress version to previous one
  39. Modify the structure of data returned by $wpdb
  40. What is wrong with this wpdb update?
  41. using $wpdb to insert a form into a post
  42. Programmatically Creating Page using $wpdb and getting 404 error
  43. wp_create_user not properly entering password
  44. Constructing a dynamic WPDB query with multiple LIKEs
  45. Foreach loop not working as expected – custom tables and references while submitting a form
  46. Query insert query executing multiple times
  47. Undefined offset: 0
  48. Connect to separate database using $wpdb and authenticate user
  49. How to access PostgreSQL using WPDB?
  50. how to use $wpdb->prepare to update a custom table
  51. Counting posts with argument without retrieving the posts
  52. how to assign content to a different author while loading content
  53. $wpdb->insert inserting only f character in custom table
  54. Getting variable from Database
  55. Create new database through static page code
  56. Custom $wpdb returns unexpected time based results
  57. Register custom table for WP to use in a plugin
  58. wpdb->get_row is selecting the variable as a column name
  59. WordPress “wpdb->update” – Append Text Value
  60. Display category names on edit user profile using $wpdb
  61. Need help converting get_user_meta [keys] into own array
  62. Can’t call WPDB inside RSS template
  63. wpdb and acf via wp rest api
  64. WPDB SQL Ignore `post_status` Parameter
  65. wpquery properties last_query and last_result : should these be public or private?
  66. $wpdb->prepare error after WordPress update [duplicate]
  67. Query and get meta as object(stdClass) on wp postmeta table?
  68. How do I query a table?
  69. check that the data exists before sending it to wpdb
  70. How to pass an input value into wpdb->Prepare
  71. wpdb->insert with special chars failing with collation utf8mb4_unicode_520_ci
  72. no result returns when using $wpdb->get_results with where clause
  73. SQL queries to another wordpress site
  74. PHP | left join avg query give me Array()
  75. update not working using wpdb
  76. get_posts() SQL Injection
  77. og:image functions.php
  78. $wpdb select returns empty array
  79. Show error messages to a user when database insert fails
  80. Debugging db calls: $wpdb->insert works on test site, not on identical production site
  81. Intermittent problem writing update_user_meta
  82. How to use WHERE NOT EXISTS query to avoid duplicate entry using $wpdb to save in custom table?
  83. Combine posts and postmeta
  84. Depreciated Call -> Function wpdb::escape()
  85. wpdb insert working in one function, but not another
  86. wp_commentdata: error in documentation?
  87. Echo only gives me the first part of string
  88. wpdb select from using array as search parameters
  89. esc_sql inserting weird chars to DB
  90. Retriving array size from serialized data
  91. How to update user profile or inputing any data to the wp db from external site?
  92. Can’t get expected result from a wpdb query
  93. Get comments after specific date
  94. selecting row using wpdb which contain special symbols
  95. Query Problem in Clustom Plugin
  96. How does $wpdb->get_var work with offset?
  97. query_vars doesn’t return query string (trying to get data from $wpdb)
  98. Table wont load into WPDB
  99. WPDB prepare – like % – placeholders?
  100. $wpdb->prepare UPDATE process not work in functions.php