Using $wpdb generates DB error

its a syntax error according to error message. starements like below might work for you.

global $wpdb;
$wpdb->show_errors();
$tableCustom = 'join_users_defis';

$sql = "SELECT * FROM {$wpdb->postmeta}";
$requeteAffichage = $wpdb->get_row( $sql );

//or $requeteAffichage = $wpdb->get_results( $sql );

var_dump($requeteAffichage);

Related Posts:

  1. Why $wpdb->show_errors() and print_error() is showing an output even if the query output is correct?
  2. How to use $wpdb to delete in a custom table
  3. get_results on large datasets
  4. $wpdb->last_error doesn’t show the query on error
  5. Is there a (better) way to access $wpdb results?
  6. How do you use prepare when asking for a list of id’s
  7. how to execute different sql query in non-sanitized $wpdb->get_results function
  8. WPDB update row with != in where clause
  9. How to update records using $wpdb?
  10. Need help writing a $wpdb query
  11. show badge with count for pending items in custom post type
  12. WP Sql query multiple where clause
  13. WordPress SQL query – returning ‘true’ ‘false’ or ‘null’
  14. Modify the structure of data returned by $wpdb
  15. Syntax for $wpdb->prepare when searching in two columns
  16. Confused by $wpdb->prepare
  17. How to display user_nicename and usermeta values by custom query in WordPress?
  18. Optimizing WordPress Queries – Removing Group By ID
  19. How can I combine one field using wpdb and group by?
  20. $wpdb->prepare with ON DUPLICATE KEY UPDATE
  21. how to use $wpdb->prepare to update a custom table
  22. WPDB Placeholders and second argument for prepared statements
  23. Increment integer field in database when WHERE needs to be dynamic [closed]
  24. Custom SQL query ORDER BY term_order
  25. Custom $wpdb returns unexpected time based results
  26. How to left join meta in queries [closed]
  27. wpdb->get_row is selecting the variable as a column name
  28. CREATE TABLE with dbDelta does not create table
  29. $wpdb query outputs php code instead of executing it
  30. wpdb query not working
  31. WordPress wpdb->insert returns int(0) => doesn’t insert anything, no errors!
  32. WPDB SQL Ignore `post_status` Parameter
  33. how to list all post that are in the custom taxonomy using $wpdb
  34. “This message was added in version X” showing a later version than current one
  35. WPDB SQL query SELECT from category
  36. Show error messages to a user when database insert fails
  37. How to use WHERE NOT EXISTS query to avoid duplicate entry using $wpdb to save in custom table?
  38. Creating an Angular factory from custom database table
  39. wpdb->update update the entire table instead of one row
  40. How do I update post based on meta_key in another table?
  41. How to set up prepared query using IN statement
  42. Custom database query to validate data
  43. Alter the main search query to search posts by coauthor user name
  44. Creates only one table and not the other
  45. Protect custom form from SQL injection
  46. looking for a way to allow users to backup the plugin db data(save as)
  47. SQL Query to select post title & post ID from a particular category
  48. Get comments after specific date
  49. query using wpdb in wordpress gets me no result
  50. Get count of rows based if column exists in two different tables
  51. query_vars doesn’t return query string (trying to get data from $wpdb)
  52. $wpdb->get_row() only returns a single row?
  53. what is the way to see the currently executing query in wordpress?
  54. Get error messages when $wpdb->insert() returns false?
  55. Multipart/formatted MySQL query problem
  56. How to make an activities stream mixing posts and comments?
  57. Delete/replace img tags in post content for auto published posts [closed]
  58. What does wp_update_post() do that the $wpdb class does not?
  59. $wpdb variable throw this error Call to a member function get_results() on a non-object in
  60. WordPress insert NOW() in TIMESTAMP column returns all zeros
  61. $wpdb prepare issue with mysql DATE_FORMAT
  62. How-To: wpdb Insert Record With Date
  63. How to pass NULL in where array for $wpdb->update
  64. Get WooCommerce product attribute taxonomies in a SQL query on WordPress database
  65. Get random row from custom table
  66. store custom WP table names in a global variable
  67. I am not understandinhg $wpdb->prepare correctly
  68. Using WPDB class
  69. What is _transient_random_seed for?
  70. wpdb get_results() and prepare when to use prepare?
  71. Foreach loop using $wpdb not results from rows
  72. What’s the proper way to add users to my site in order to test things?
  73. Q: How to pull data from custom table to populate zustomizer setting/control select options
  74. Code only works every other time its run
  75. I can’t figure out what’s wrong with this statement. $wpdb->query update
  76. Can’t pass variable in wordpress wpdb->get_results
  77. Problem in using wpdb
  78. How do I count columns on a custom WPDB query?
  79. Trouble inserting string containing quotations marks with wpdb in save_post hook
  80. How can I add a new row in a separate database when someone registers via WordPress?
  81. Clear Terms from Taxonomy for Specific Post IDs?
  82. $wpdb->insert() doesnt work anymore
  83. $wpdb->get_results not returning an array
  84. WPDB Query Question with Category Only
  85. wpdb result arrray inside an array
  86. Fetching review value using wpdb class
  87. $wpdb->num_rows doesn’t work
  88. How capturate wpdb exceptions?
  89. Limit left join
  90. Get records from Formidable Table using $wpdb->get_col
  91. What argument does my function need to echo get_results() query results
  92. Missing argument 2 for wpdb::prepare() [duplicate]
  93. Save customizer default values to DB on theme activation
  94. Plugin with connection to database – Single function
  95. wpdb->update error
  96. Wpdb generates too many queries
  97. Using $wpdb to update current post
  98. DBDelta: “table doesn’t exist” for a table that was just created
  99. Table wont load into WPDB
  100. WPDB prepare – like % – placeholders?