How to get row value from wpdb

As @nmr says, $row is an array of objects. You’ll need to foreach these – and do the check in the foreach like this:

foreach ($row as $item) {
    if($item->notification == '1') {
        echo 'Yes';
    }
}

And there’s no “notification” column as far as I know.

Also, can you explain what you’re trying to achieve? Maybe there’s an easier way to achieve your goal.

Best regards

Related Posts:

  1. $wpdb->get_row() only returns a single row?
  2. what is the way to see the currently executing query in wordpress?
  3. Fetch array with $wpdb
  4. $wpdb->last_error doesn’t show the query on error
  5. Theoretical Multi-Server WordPress Setup with Shared Users
  6. Delete/replace img tags in post content for auto published posts [closed]
  7. What does wp_update_post() do that the $wpdb class does not?
  8. $wpdb is get_results escaped
  9. wpdb-> not adding prefix to custom table
  10. WordPress insert NOW() in TIMESTAMP column returns all zeros
  11. $wpdb prepare issue with mysql DATE_FORMAT
  12. How-To: wpdb Insert Record With Date
  13. How to pass NULL in where array for $wpdb->update
  14. Get random row from custom table
  15. store custom WP table names in a global variable
  16. wpdb prepare: passing varible number of fields as second argument
  17. I am not understandinhg $wpdb->prepare correctly
  18. Wpdb query for comment meta for current post
  19. How to save html and text in the database?
  20. XOR functionality for meta_query
  21. How to Modify this $wpdb query to accept an array of post statuses
  22. Using WPDB class
  23. WPDB Update using Conditional Arrays
  24. How can I migrate mysql_fetch_array to $wbpdb?
  25. What is _transient_random_seed for?
  26. Get published posts and pages?
  27. wpdb get_results() and prepare when to use prepare?
  28. Foreach loop using $wpdb not results from rows
  29. Return XML of Post Metadata
  30. What’s the proper way to add users to my site in order to test things?
  31. Optimizing WordPress Queries – Removing Group By ID
  32. External DB Connection [closed]
  33. Problem in inserting row to custom database table
  34. sanitize_text_field and apostrophe problem
  35. $wpdb->prepare with ON DUPLICATE KEY UPDATE
  36. Code only works every other time its run
  37. wpdb updating record in wordpress with json adds extra array elements
  38. How to display a specific category using a custom Query?
  39. Can’t pass variable in wordpress wpdb->get_results
  40. AWS Bitnami WordPress – SELECT command denied to user
  41. WPDB Placeholders and second argument for prepared statements
  42. PHP Fatal Error – $wpdb a non-object?
  43. WordPress db prepare
  44. How do I count columns on a custom WPDB query?
  45. how to get db values without using an loop with wpdb->get_results()
  46. Custom SQL query ORDER BY term_order
  47. Trouble inserting string containing quotations marks with wpdb in save_post hook
  48. $wpdb->prepare was called incorrectly when inserting multiple records
  49. How to protect a script execution on WordPress?
  50. get_results query with accent
  51. Is querying wpdb directly and skipping actions provided by WP’s core “wp_update_post” a good idea?
  52. how to connect to another database in wordpress
  53. $wpdb->insert() doesnt work anymore
  54. wpdb query not working
  55. Where can I see MySQL hostname and port for wp-config.php
  56. WordPress wpdb->insert returns int(0) => doesn’t insert anything, no errors!
  57. Using “->” in a page to exceute $wpdb query gives error
  58. Perform a function when a user clicks register button
  59. $wpdb->get_results not returning an array
  60. Get all sticky posts from one user through user ID
  61. WPDB Query Question with Category Only
  62. wpdb result arrray inside an array
  63. $wpdb->num_rows doesn’t work
  64. $wpdb->get_var next var?
  65. How can I change my meta_query to SQL wpdb query?
  66. How do I modify this wpdb query to include posts that have a post_status of publish and draft?
  67. Can’t find out why dbDelta dosen’t create my table
  68. How capturate wpdb exceptions?
  69. Limit left join
  70. Check if Value Exists in Database, adding row details to variables and echoing result
  71. wpdb discards duplicate column names?
  72. Get records from Formidable Table using $wpdb->get_col
  73. Prepare WPDB with meta key and meta value
  74. WPDB SQL query SELECT from category
  75. I am using wpdb but it not working perfectly.but if I dont use form data its work
  76. wont add form details to database or send me mail
  77. Get last element from wpdb as a string
  78. Missing argument 2 for wpdb::prepare() [duplicate]
  79. wpdb->update update the entire table instead of one row
  80. WPDP related functions look to work but they don’t
  81. Save customizer default values to DB on theme activation
  82. Plugin with connection to database – Single function
  83. Alter the main search query to search posts by coauthor user name
  84. Update all fields of table with ON DUPLICATE KEY UPDATE command
  85. WordPress – wpdb query does not list same result as sql query
  86. Protect custom form from SQL injection
  87. why nl2br() is adding an extra ?
  88. What is the best practice to initialise $wpdb by loading wp-load.php?
  89. How to add more custom fields in user meta table simultaneously
  90. wpdb->update error
  91. get unserialized array without using get_option()
  92. SQL Query to select post title & post ID from a particular category
  93. Create Table Failed Column Date DateType
  94. Using $wpdb to update current post
  95. Checking if meta_value exists for any user
  96. Jeditable Plugin working as it should – scope issue?
  97. Can you create a new wpdb that connects to an SQL (not MYSQL) database? [duplicate]
  98. DBDelta: “table doesn’t exist” for a table that was just created
  99. query using wpdb in wordpress gets me no result
  100. WP Recommended Table Exclusions?