You have a double quoted string, so your table name literally contains .'my_employees'
Try the curly syntax instead:
"SELECT *
FROM {$wpdb->prefix}my_employees
WHERE ID = 1
";
Related Posts:
- Undefined function mysql_connect()
- MySQL column count doesn’t match value count at row 1 [closed]
- dbDelta support for FOREIGN KEY
- How to correctly submit a search form and display the result in an independent page
- Check if post of title already exists
- $wpdb->delete column values IN ARRAY()?
- Custom SQL query to get List of posts with featured image url
- Does WordPress cache get_user_meta() results?
- Delete post revisions on post publish
- Using Echo in ShortCode – Stuck
- Problems migrating WordPress to localhost
- error importing localhost export file to server
- How to sort results from a custom database table
- Update some database fields when post is saved
- sql query to put quotes around numbers in img tag
- No wp-config.php file on local install of wordpress – site still displays
- Use ajax to update_post_meta
- What SQL / WordPress queries would need a nonce?
- Different database query in function.php using mysqli
- Strange wordpress slowness
- Setting All Drafts to ‘exclude-from-catalog’ in WooCommerce
- How to securely provide a $_POST var in WP_Query with PHP 7?
- Create WP_Query to search for posts by their categories or their parent/child categories
- WSoD being caused by this piece of code
- How to display data from custom table in wordpress phpmyadmin
- Update results, Before deleting the related category [closed]
- get_posts() and WP_query limits ‘AND’ conditions to a maximum of 6 for meta value queries in WordPress
- Replacing mysql_escape_string in a custom plugin when moving to PHP7
- Weird 404 URL Problem – domain name being placed at end of urls
- database sent to a JSON file
- $wpdb->insert() does not Insert record in a table
- Using custom tables for old posts
- Help with a $wpdb MySQL Query
- How i can obtain all the post meta for a specific post as an array?
- Multiple meta_key in one global $wpdb;
- WordPress member notification
- $wpdb returns duplicate posts
- Update postmeta after theme switch
- Mixing variables into an array when inserting values
- wpdb prepare insert table doesn’t work
- Should I use WordPress to skin a database website?
- Creating Database Table vs. Adding MetaData to Post & User
- WordPress Custom SQL Table with UserID Filter for results
- How can I add a new row in a separate database when someone registers via WordPress?
- I can’t update my data through $wpdb
- Output: “Array”
- How to use mysql LIKE with wpdb?
- Submitting a form, using Ajax, to run a SQL Select query based on user input from the form
- WordPress WP_Query without query GET parameters
- How to use AJAX in WordPress in MYSQL query?
- Use variable in SQL statement
- Processing ajax call to php to insert into mysql database
- WPDB secure custom form
- phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
- Query the links Database
- WordPress Custom Query: Combining Two Functions
- MySQL Query Returns Array () In Shortcode
- How to WP_Query posts order by parent title?
- Passing in MySQL prepare statement parameter separately throwing error
- Convert a column of a table containing an Array as response in HTML
- Database SQL query error
- Display Results of SQL Query on WP site
- PHP Warning: mysqli_query(): after updating my websites php from 5.6 to 7.2
- MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
- Updated Php version from 5.4 to 7.2 and getting “PHP installation missing the MySQL extension needed by WordPress”
- how to get data from two different table from wordpress database
- Passing Current User ID into SQL statement
- How to optimize and reduce excessive database queries
- How to display MySQL table data which is stored as an array?
- Store GA Client ID in User DB
- How to import woocommerce custom fields data into another site?
- PHP 7.2.18 | Your PHP installation appears to be missing the MySQL extension which is required by WordPress
- Windows Setup: Error establishing a database connection
- Need help with format of nested array in MySQL
- WAMP SERVER Command Prompt SET PATH=%PATH%
- Inserting other fields to existing registration form in a WordPress theme
- Advanced WordPress SQL Query
- Splitting table data to pages with numbers
- Site doesnt work once PHP changed to 7.1
- How to detect if a revision was made by woocommerce or wordpress?
- WordPress WPDB::insert 13th param is always blank (only if format)
- Ajax not updating to database
- can’t delete a row from post_meta table
- MySQL query in WordPress with AJAX
- Processing forms with php to wordpress database
- MySQL queries in WordPress
- retrieve wordpress post-meta using php not wordpress functions
- Splash pages on a high traffic site
- Using the same shortcode to show any table from the database
- Let users register weight each day and save it in DB
- I am unable to fetch json data from wp_db
- Submit cf7 form to cfdb as pdf/BLOB [closed]
- How to send push notification in android using php? [closed]
- Execute multiple PHP Snippets causes error?
- what to do after instlling cyberpanel on VPS
- running an existing WordPress site from Visual Studio Code?
- WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax [closed]
- Global update of records after import WP All Import Pro
- Updates applied to staging WordPress site affecting production even with different databases
- WordPress Query with meta_key and order by another meta_key