SQL syntax error when getting data for a url

Are you sure you didn’t mean $wpdb->staff? By ommitting the $, the query now looks for a table called wpdb->staff, which isn’t valid SQL

As an aside, had you considered using a custom post type/user meta instead of a custom table? Or even a custom taxonomy on users?

Note as well that if you never set $wpdb->staff, it won’t exist, so you’d be better using the table prefix combined with a hardcoded table name

Related Posts:

  1. Column count doesn’t match value count at row 1
  2. Access denied for user ‘root@localhost’ (using password:NO)
  3. MySQL error 2006: mysql server has gone away
  4. Which MySQL data type to use for storing boolean values
  5. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  6. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  7. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  8. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  9. Your password does not satisfy the current policy requirements
  10. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  11. What is the definition of cardinality in SQL
  12. How to restart remote MySQL server running on Ubuntu linux?
  13. what does “/index.php?admin/admin_dashboard” in my url mean
  14. How to join two tables by multiple columns in SQL?
  15. How to get size of mysql database?
  16. Selecting data from two different tables without using joins
  17. SQL – Update multiple records in one query
  18. Difference between VARCHAR and TEXT in MySQL
  19. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  20. mysqladmin: connect to server at ‘localhost’ failed
  21. mysql update multiple columns with same now()
  22. Usage of MySQL’s “IF EXISTS”
  23. Simple Random Samples from a Sql database
  24. What does SQL clause “GROUP BY 1” mean?
  25. Generating a random & unique 8 character string using MySQL
  26. MySQL > Table doesn’t exist. But it does (or it should)
  27. SQL select only rows with max value on a column
  28. Trying to perform MINUS operation in MySQL
  29. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  30. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  31. MySQL config file location – redhat linux server
  32. How to create a foreign key in phpmyadmin
  33. Can’t create test file lower test start server mysql
  34. MySQL delete multiple rows in one query conditions unique to each row
  35. Create boolean column in MySQL with false as default value?
  36. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
  37. Is there a naming convention for MySQL?
  38. CAST to DECIMAL in MySQL
  39. Is merge statement available in MySQL
  40. GROUP_CONCAT comma separator – MySQL
  41. Failed to Connect to MySQL at localhost:3306 with user root
  42. How do you properly prepare a %LIKE% SQL statement?
  43. Set page template for all pages?
  44. SQL query to update post_date (one post = one single date & time)
  45. My WordPress site always displays a cached version of its homepage
  46. How to copy post titles to post slug in phpmyadmin
  47. If I consider changing my WordPress DB tables to InnoDB, will it have an effect on the way WordPress works?
  48. Proper way to work with wpdb to get user’s firstname
  49. How to change post format from Aside to Image for all posts?
  50. Inserting Hundreds of Thousands of Posts at Once
  51. wp_admin edit.php slow with lots of queries
  52. Database: Custom table: sprintf value for DateTime column
  53. can database and media folder be moved to a different drive?
  54. What is the most secure way to set up the MySQL user in WPMU?
  55. Find duplicate posts with same slug and author
  56. WP_USE_EXT_MYSQL
  57. Distinction on meta value on pre_get_posts
  58. How to get data from WordPress site sql file
  59. WordPress with php5-fpm and nginx
  60. MySQL Rank & $wpdb
  61. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  62. WordPress post_status is future, manually added
  63. How are multiple WordPress WPDB queries handled?
  64. $wpdb to insert html form information
  65. Proper usage of $wpdb->update()?
  66. Regarding “Insert query error” in wordpress
  67. MySQL 5.5 upgrade ‘broke’ WordPress [closed]
  68. WordPress plugin overloading with tmp tables
  69. Site not responding error – taking long to load [closed]
  70. What should a WordPress developer know about MySQL? [closed]
  71. Copyright: Get first and last date of post type
  72. WordPress(wpdb class) and mysql stored procedures
  73. WordPress plugins for database queries
  74. Query posts by custom taxonomy and sort by post_modified
  75. WordPress $wpdb get posts from category and sort by custom meta
  76. WordPress tables and aliases?
  77. What’s the sql for this condition?
  78. Copy usermeta value where ID matches in the same table
  79. Array Formation Issue
  80. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  81. WordPress $wpdb no result
  82. (WP List Table) How to sort by SKU and Custom Fields?
  83. User set date and time from frontend doesn’t get stored into database
  84. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  85. How to run SQL query from WordPress ‘WP Crontrol’ plugin
  86. How to bulk delete a certain part of all wordpress posts
  87. edit_user_created_user hook – using to update Groups
  88. Mysql Error in querying form entries in Gravity Form plugin
  89. update_option returns false in AJAX, how to debug?
  90. Improving performance of SQL sub-queries in WordPress
  91. Saving custom term value to the database in new table
  92. MySQL errors after a WordPress clone
  93. MYSQL Join on meta key value?
  94. Complicated MySQL Query
  95. problem with quotes on new post
  96. Where other than wp-config can database access details be defined?
  97. Why does the MySQL command line tool ignore the –port parameter?
  98. Postgres equivalent to MySQL’s \G?
  99. Changing host permissions for MySQL users
  100. Possible SQL injection. How to locate and fix?