wpdb Cannot Access Associative Array Data in a Count Query

You can simplify that by using $wpdb->get_var.

$total = $wpdb->get_var( "SELECT COUNT( * ) AS total FROM tableA" );
echo "Total Records:" . $total;

However, the code you’ve got should work– either version of it. I tested both.

The only thing I notice is that the first version of the code should give you Array ( [0] => Array ( [total] => 2 ) ). Where is cnt coming from?

Related Posts:

  1. Fetch array with $wpdb
  2. Create an array with a string key from wpdb->get_results
  3. How to fetch an array in $wpdb?
  4. Save data from a checkbox to a wpdb array
  5. PHP | left join avg query give me Array()
  6. Access to numerically indexed array in wpdb Class and undefined offset
  7. Get 3 row ID’s via ARRAY_A
  8. $wpdb->get_results in not an array
  9. Echo only gives me the first part of string
  10. wpdb select from using array as search parameters
  11. How do I fetch each row as an associative array using $wpdb?
  12. $wpdb->get_row() only returns a single row?
  13. wpdb->insert: do I need to prepare against SQL injection?
  14. How to parse row results from $wpdb -> get_results
  15. Why $wpdb->show_errors() and print_error() is showing an output even if the query output is correct?
  16. what is the way to see the currently executing query in wordpress?
  17. How do I check for a duplicate record before inserting using wpdb
  18. WordPress 4.8.1 uses mysql_connect which doesn’t work with PHP 7
  19. How to use $wpdb to delete in a custom table
  20. $wpdb->insert not working in any way
  21. WPDB prepare – like % – placeholders?
  22. $wpdb->update multiple rows, like IN in normal SQL
  23. Matching database content types to PHP types
  24. Does $wpdb->prepare not create a prepared statement that I can execute multiple times?
  25. get_results on large datasets
  26. $wpdb->insert() and Values for Datetime Columns?
  27. $wpdb->last_error doesn’t show the query on error
  28. Avoiding “Usage of a direct database call is discouraged”
  29. dbDelta does not create Table, but returns success
  30. Theoretical Multi-Server WordPress Setup with Shared Users
  31. Change post status based on meta value
  32. wpdb->insert not working
  33. Saving custom form data into database
  34. passing variables as parameters to stored procedures via wpdb from php-script
  35. Get data from database table by post_id to get data from second database table
  36. wp-content/db.php : where is this file?
  37. Quotes in table name
  38. Delete/replace img tags in post content for auto published posts [closed]
  39. $wpdb sql help. Select post id and post meta value based on 2 other post_meta values
  40. $wpdb->get_results() returns good result only in first foreach iteration
  41. $wpdb->insert – inserting multiple rows
  42. Speed optimization of $wpdb->get_results
  43. How do I create a single.php for a specific category?
  44. $wpdb prepared with search term
  45. WPDB->insert with special characters
  46. What does wp_update_post() do that the $wpdb class does not?
  47. How Can I Use $wpdb in PayPal IPN file?
  48. $wpdb is get_results escaped
  49. $wpdb->query() multiple query support
  50. wpdb-> not adding prefix to custom table
  51. Is there a (better) way to access $wpdb results?
  52. Using $wpdb generates DB error
  53. WordPress insert NOW() in TIMESTAMP column returns all zeros
  54. How do you use prepare when asking for a list of id’s
  55. Set media metadata (i.e. “dimensions” field) on SVG file after extracting it with a filter
  56. $wpdb prepare issue with mysql DATE_FORMAT
  57. How-To: wpdb Insert Record With Date
  58. $wpdb->prepare not working with update table prefix
  59. How to use prepare to query with variables
  60. Use $wpdb in wordpress theme files
  61. How to pass NULL in where array for $wpdb->update
  62. how to execute different sql query in non-sanitized $wpdb->get_results function
  63. $wpdb not returning data
  64. Get random row from custom table
  65. How to get top 10 user is based on user meta value
  66. When and why should I use $wpdb different return types?
  67. $wpdb Query Result not coming but in phpmyadmin it works [closed]
  68. WPDB update row with != in where clause
  69. store custom WP table names in a global variable
  70. wpdb prepare: passing varible number of fields as second argument
  71. $wpdb insert array
  72. I am not understandinhg $wpdb->prepare correctly
  73. Wpdb query for comment meta for current post
  74. How to update records using $wpdb?
  75. wpdb->get_row() / get_results – is it possible to return an object instances of my own class?
  76. Problem in creating table through plugin code
  77. I want to update my postcontent with $wpdb
  78. How to save html and text in the database?
  79. XOR functionality for meta_query
  80. How to email user after inserting the username in database in WordPress
  81. $wpdb->replace / Replace or update primary key
  82. Join inside a wpdb query.. confused!
  83. $wpdb – do you have to use foreach even if there will always only be one result?
  84. How to Modify this $wpdb query to accept an array of post statuses
  85. Replicating the WP_Query ‘s’ param with $wpdb
  86. Why doesn’t my insert query work?
  87. Need help writing a $wpdb query
  88. How to prevent $wpdb->prepare stripping a leading zero in variable value?
  89. Generate a unique hash/number for tracking on $wpdb insert
  90. How to use IN array properly in WordPress?
  91. get the number of queries made on a page(inside my plugin)
  92. Doing a loop with multiple DBs simultaneoulsy
  93. Using WPDB class
  94. show badge with count for pending items in custom post type
  95. WPDB Update using Conditional Arrays
  96. $wpdb->insert query changes to SHOW COLUMNS query Output
  97. How can I migrate mysql_fetch_array to $wbpdb?
  98. $wpdb->get_results returns empty but value exists
  99. Fixing wpdb->get_results and wpdb->prepare?
  100. How does the WXR file differ from the WPDB?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)