Undefined variable: row?

First, it’s not $wpdb->wp_posts, it’s just $wpdb->posts.

Second, you’re using prepare() incorrectly. You use prepare when you have some variable data that you need to safely insert into the query string, not otherwise. Using prepare on a known string does nothing and throws a warning.

For example:

$data="example string"
$query = $wpdb->prepare("SELECT post_title FROM {$wpdb->posts} where post_title = %s", $data);

And then $query will be the SQL string that you’re able to safely send to $wpdb->query. The string gets escaped, quoted, and inserted where that %s is.

If you don’t have any variable data that needs to be prepare’d for inserting into the query, then there’s no point in calling prepare.

For your case, since you’re not putting any variables into the SQL, just skip the prepare.

$test = $wpdb->get_var( "SELECT post_title FROM {$wpdb->posts}" );

Related Posts:

  1. wpdb::prepare was called incorrectly
  2. Why is variable not working on custom sql query using wpdb?
  3. Get stock by custom meta field on all Woocommerce variable products
  4. Any possible way to make $wpdb->get_results() return anything else than array?
  5. Echo a hierarchical list of post data from custom fields
  6. wpdb php get_var query to get ID for URL image doesn’t work for ID over 999
  7. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  8. Can’t update multiple rows with $wpdb query
  9. PHP -> SQL Query with Summing
  10. Why my query does not run with prepare
  11. the_date() not working
  12. How to return number of found rows from SELECT query
  13. Can i use php sql functions instead of $wpdb?
  14. How to order WP_User_Query results to match the order of an array of user IDs?
  15. Custom query to get post names beginning with a digit
  16. WPDB: how to get the value of a field in a custom database table
  17. Can’t use get_results() in ajax query
  18. PHP syntax error when using wpdb update?
  19. my function doesn’t return my post from today
  20. “The plugin generated 2694 characters of unexpected output…” on Plugin activation, CREATE TABLE sql command not working
  21. Display related products with custom output
  22. WordPress get pagination on wpdb get_results
  23. Multiple choice in a custom taxonomy
  24. Show MySQL errors that occur when I excute $wpdb->insert()
  25. how to delete 30 day old data using PHP [closed]
  26. Display fields as values in array from external SQL DB
  27. WP Query with custom Shortcode
  28. Getting id of poll from WP database
  29. Storing Array from returned database query and using the array in a new query
  30. I want to select the from values from database in WordPress? [closed]
  31. WordPress 3.2 query_posts and pagination, permalinks issue
  32. only show container with next/prev links if they exist?
  33. What query string parameter is available for index.php, that works for both pages and blog articles?
  34. Querying wpdb using PHP
  35. Long running queries
  36. register_taxonomy() take much queries
  37. Help with a $wpdb MySQL Query
  38. Odd / Even posts add class minus first post
  39. unable to use ‘new WP_Query’ in AJAX call
  40. Custom array from a query only write the last row of the query
  41. Parse error: syntax error, unexpected ‘}’ on get_the_author_meta [closed]
  42. Querying Database with wpdb
  43. How to add div blocks after certain set of post
  44. $wpdb returns duplicate posts
  45. Wpdb->insert() doesn’t insert new row after the last one
  46. WordPress query undefined offset in loop
  47. Can I make get_users() query global?
  48. Use $wpdb or other PHP script method to find/replace in WP database
  49. Issue with custom loop in Archive page
  50. How to get specific attribute from DB
  51. Parse error: syntax error, unexpected ‘}’ [closed]
  52. How to hide posts of a specific custom category in WordPress?
  53. How to insert wp_users ->user login name to wp_terms when a new user registering?
  54. Change MySQL PDO connection to a WPDB connection
  55. How to get thumbnail with pure PHP in a WordPress database?
  56. $wpdb->get_results breaking page?
  57. WPDB secure custom form
  58. mySQL queries are executed twice on wordpress website
  59. Echo array value
  60. Call to a member function get_row() on a non-object, Unable to use global $wbdp inside a plugin
  61. Query the links Database
  62. Fetching review value using wpdb class
  63. Query pulling a single post per month
  64. WordPress Custom Query: Combining Two Functions
  65. SQL error with custom query
  66. MySQL Query Returns Array () In Shortcode
  67. Isn’t Returning Value While Using SELECT COUNT(*) FROM {$wpdb->prefix}
  68. Reject all malicious URL requests functions.php
  69. Advanced Query posts
  70. How can I check that the acf field value is not a duplicate when adding a post?
  71. WordPress SQL Prepare
  72. My Custom Post Type AJAX Query is Returning no posts – why?
  73. array wordpress when get is null
  74. What is the correct way to search 3 custom fields only in WordPress?
  75. Why does a header location on admin_head remove the query var I’m setting in the location?
  76. 403 Forbidden WordPress Database Results
  77. getting the values of hidden inputs to use them in a php mysql query
  78. Offset with ajax load more posts duplicates
  79. problem in using wpdb->prepare and a string placeholder
  80. Query doesn’t display text data with apostrophes
  81. How to make a parent page for author.php?
  82. Advanced WordPress SQL Query
  83. Echo multiple tasks if a common function exists
  84. MySQL query in WordPress with AJAX
  85. Accessing external database: ERR_INCOMPLETE_CHUNKED_ENCODING
  86. How to enqueue assets only on queried pages, excluding the page being queried?
  87. MySQL queries in WordPress
  88. At what point during a typical request does the $wpdb object become available?
  89. Get null from POST
  90. Arrange Category post manually when displayed
  91. Fetching wpdb data from a php file seems to break?
  92. wp_query on search results page showing all results every time
  93. WP_Query not returning results
  94. Insert into db with foreach problem
  95. posts_clauses drop ACF get_field function
  96. inner-wrap div pushing custom table far down on page
  97. Sorting a custom post type in pre_get_posts
  98. I have an error WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version
  99. SQL query to retrieve the number of WordPress posts with all given categories
  100. Putting form result in my database