Really simple query giving error in SQL syntax

Don’t use $wpdb->prepare with table names. prepare will quote your table names that will result in incorrect SQL.

It is unnecessary overhead as well. Your table name should never, and in your case isn’t, be user-supplied data. You have no need to escape it. ‘prepare’ is for use on user-supplied data, such as data from a form or a $_GET parameter.

You have no user-supplied data so all you need is 

$wpdb->get_results("SELECT * FROM {$tablename}");

Related Posts:

  1. Retrieving custom fields with $wpdb->get_results
  2. SQL query for custom taxonomy slugs
  3. How to optimize multiple insert into wordpress database
  4. How to store sensitive user data (passwords)
  5. I can’t write in my DB using $wpdb->insert
  6. Should I use wpdb prepare?
  7. Is it mandatory to use $wpdb->prefix in custom tables
  8. $wpdb->insert_id
  9. Check for success of $wpdb->update() correctly
  10. Getting wrong relationship value in $args in wp_Query?
  11. WordPress and multithreading
  12. $wpdb->insert is changing a value
  13. Actions or filters fired when data is saved in a custom table
  14. Display only certain posts based on visitor’s country?
  15. Custom Plugin Database relations
  16. why creating tables using $wpdb is not being executed while installing plugins?
  17. How to use mysql IN statement with wpdb update method?
  18. How to add SQL file with PHP to WordPress database [closed]
  19. Using $wpdb object in a widget
  20. Activation hook not creating table
  21. $wpdb -> Batch insert from XML File?
  22. How to Download and install plugin database remotely
  23. How to insert data to a database table when the field is not yet created?
  24. Where to store the name of a custom table?
  25. include wp-blog-header not working on MAMP
  26. creating custom function to log actions in plugin
  27. Issue regarding $wpdb->prepare()
  28. Error on inserting a form value to database
  29. How to create database table, add data, update and delete using wpdb via plugins?
  30. Using WPDB to output raw XML fails because of wp-blog-header.php
  31. how to search users by ajax live search
  32. Adding custom end points, No error line
  33. Intermittent database errors when accessing WordPress database
  34. Storing data in wordpress database from ajax call from different website
  35. wpdb->prepare and mysql UPDATE – how is it done?
  36. $wpdb->prepare with LIKE and sprintf
  37. $wpdb->update() always need a second try
  38. Using AND and bracket grouping in SQL not working
  39. Data inserted by wpdb insert is different than data pressnt in database.
  40. Proper Prepare Statement for ALTER TABLE and using AFTER
  41. wpdb->get_var always returning 0
  42. $wpdb->prepare is not working like mysql_real_escape_string
  43. How to avoid conflicts with db.php / $wpdb and other plugins that decide to use them?
  44. $wpdb in php 5.5
  45. Plugin to create Posts and Forums then choose category and parent forum
  46. $wpdb->update Issue
  47. How to relate the Category to user?
  48. WordPress database error: [Query was empty] – using $wpdb->prepare()
  49. Why doesn’t my Table get created?
  50. How to display specific data from a custom table to logged in users with a custom role
  51. $wpbd->insert_id is returning null
  52. How to get inserted row IDs for bulk/batch insert with wpdb query?
  53. WordPress Query doesn’t return the correct value
  54. User avatar-ACF fields
  55. bindParam? WordPress 4.9.5 SQL LIKE statement %s and %LIKE%
  56. Update database record in plugin
  57. Organising and completing posts (mark as read and hide)
  58. Dedicated server and WPDB Class : huge slow-down of the website
  59. How to implement pagination into a wpdb->result query?
  60. How to CRUD from wordpress database in wordpress theme?
  61. $wpdb how can i save my postmeta table before querying it
  62. How to add chunk of php, html, and sql code to variable an append to $content
  63. WordPress plugin tables become corrupt
  64. Nothing happens on WordPress Update command
  65. Fixing plugin for wpdb::prepare
  66. Get all the related data from WordPress DB
  67. select rows based on exact time (hours, minutes and seconds)
  68. multiple record insert creating many duplicate records
  69. Is there any plugin development framework
  70. How do I add CSS options to my plugin without using inline styles?
  71. Handling results from data hooked into admin_post
  72. Get list of available wordpress actions
  73. How can i list current author’s categories?
  74. Handling form request from plugin file
  75. Finding the paragraphs in content
  76. A better way to include localized labels in WordPress plugins
  77. Clearing caches on plugin uninstall
  78. plugin settings – uploading multiple files with a single button
  79. Getting term_id for newly created or edited term
  80. How to insert text at the current cursor position in Gutenberg?
  81. How to fix this URL error in WordPress ” data-wplink-url-error=”true”>
  82. Edit Images From the Front End without Access to WP Admin
  83. How to remove or add submenu item on plugin activate or deactive
  84. jQuery in WordPress Plugin
  85. Why is my plugin version 0.1?
  86. WP Plugin Running before jQuery
  87. How to include jQuery into my plugin so I can use it on plugin page?
  88. WordPress multisite,use same cookies across all website?
  89. How to save post meta as an array in Gutenberg?
  90. Duplicate shipping method logic to another shipping method [closed]
  91. REST Endpoint API 404
  92. How to disable a jQuery plugin on WordPress plugin page
  93. jQuery UI tab does not work in the plugin page
  94. Using HTML links within translatable string
  95. Adding an external stylesheet to a plugin
  96. How to write a custom shortcode name book?
  97. get the term_id of current taxonomy page
  98. Custom query not working in plugin admin page
  99. Developing Themes on WordPress, Looking for Excellent Tutorials [closed]
  100. User set default settings for a Block in Site Editor

Leave a Comment