if you’re communicating with the WordPress database itself, try using $wpdb->prepare() on your select string before running it as $wpdb->query() – it should format it for you.
Further reading: Codex
Related Posts:
- Transaction when using WP functions rather than vanilla SQL?
- $wpdb->get_results(…) returns empty array despite correct query
- How to get the list of WooCommerce product image of a certain category from database?
- How to make WordPress plugin check for database changes and then do something?
- Alter query on edit.php
- How to auto login user again after change user_login
- How to display multiple Post meta_key/meta_values by SQL query
- How to Join two tables from separate databases within WordPress
- count number of user comments with a specific comment meta value
- Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
- WPDB: how to get the value of a field in a custom database table
- Database “Migration” for Plugins?
- my function doesn’t return my post from today
- Enhanced WordPress Search
- Automatically generate Post/Page from searched Database item?
- List of posts by day of the week
- register_activation_hook isn’t adding table to DB
- How to display posts of specific category using a custom Query in WordPress?
- What SQL / WordPress queries would need a nonce?
- Renaming post IDs – Okay to do?
- How to generate page content from database the right way?
- phpMyAdmin displays error when importing database
- Preferred Method of debugging a wordpress SQL calls?
- Get Current User Id Inside a Loop Returns 0 For a Shortcode
- Get stock by custom meta field on all Woocommerce variable products
- Transferring working local PHP site to wordpress – with database (MySQL)
- how to delete 30 day old data using PHP [closed]
- Display fields as values in array from external SQL DB
- Importing Geo data into wordpress database
- Detect session/cookie variable in wordpress to prevent access to documents
- Querying wpdb using PHP
- WP_Query adds “(wp_posts.ID = ‘0’)” so no results are returned
- Archive post by meta value + 24hours
- Genesis framework comments broken?
- $wpdb->insert() does not Insert record in a table
- Databases – Submitting data from inputs to database [closed]
- Is it best to avoid using $wpdb for security issues?
- dynamic page using php from sql database
- Use $wpdb or other PHP script method to find/replace in WP database
- How to Update post_modified of all wordpress post
- Correct PHP to output a single result of a Function with SQL Query
- How can I add a new row in a separate database when someone registers via WordPress?
- PHP -> SQL Query with Summing
- Lost in trying to create user database system
- Pull MySQL data from multiple tables and merge into 1 PHP array
- Filter results from a serialized string to use on statistics
- wordpress site – using custom database and PHP
- Searching Posts Programmatically in a WordPress Plugin
- Use variable in SQL statement
- Why my query does not run with prepare
- wpdb getting avatars and author url
- mySQL queries are executed twice on wordpress website
- making php value numeric
- Using color schemes with Color Picker
- WordPress SQL JOIN query
- Fetching review value using wpdb class
- Remove password protection from all posts
- wordpress sql posts query won’t display the latest post in a specific category
- Display latest post from WordPress Featured Category that is also in X,Y,or Z categories
- WP_Query: How to get results from both meta_key options?
- get_terms with specific id order
- Database SQL query error
- get different meta-data of a complicated query at the same time
- WordPress SQL Prepare
- Build A Custom SQL Query for WordPress Search
- How to run complex query using PHP
- Storing huge number of users in wordpress
- add role on WordPress in PHP on a second database
- Trying to create a shortcode to display categories with a specific product tag
- Fetch Data from an external MSSQL Database in a Managed WP hosting
- Run a sql (update) after 12 hours after the user login. Woocommerce users
- Creating multiple tables with Plugin
- Custom User registration system
- How to use Multi SQL Database in WordPress?
- Woocommerce – get daily sales meta
- Running a PHP SQL script on a wordpress page
- Collect all events in one year
- WordPress search query, how to modify the sql
- How do I get data from my database into my Custom Export Field
- Inserting other fields to existing registration form in a WordPress theme
- Getting error in sql query
- user update profile for custom code
- Where to check in PHPmyAdmin / SQL database for subdomain
- Front end/Database connection in WP
- Plugin Modification Change Functionality For Logged User Only
- SQL Query Search page
- direct query to post_meta table
- can’t delete a row from post_meta table
- What to create new post using wp_insert_post, but it repeat the post infinitely
- Querying multiple meta_keys in WordPress SQL query
- How to export database correctly for local to online
- How can I order metaboxes in my posts in WordPress?
- Search results always returns “No results” no matter what
- Can’t send form data to wpdb when URL has query string
- Retrieve data from external database and insert back in
- SQL query to retrieve the number of WordPress posts with all given categories
- How to sort search result by post_title, then by post_content
- Help writing out comments and replies
- Where is WooCommerce order shipping methods stored
- How to properly prepare a column name if passed to a stored procedure?