$wpdb->get_results() returns an index array of row objects, but it looks like you’re expecting $exists to contain the actual value of the used column. you probably want $wpdb->get_var(): http://codex.wordpress.org/Class_Reference/wpdb#SELECT_a_Variable
Related Posts:
- How to use $wpdb to delete in a custom table
- get_results on large datasets
- Is there a (better) way to access $wpdb results?
- Using $wpdb generates DB error
- How do you use prepare when asking for a list of id’s
- how to execute different sql query in non-sanitized $wpdb->get_results function
- WPDB update row with != in where clause
- How to update records using $wpdb?
- Need help writing a $wpdb query
- show badge with count for pending items in custom post type
- WP Sql query multiple where clause
- Modify the structure of data returned by $wpdb
- Syntax for $wpdb->prepare when searching in two columns
- Confused by $wpdb->prepare
- How to display user_nicename and usermeta values by custom query in WordPress?
- Optimizing WordPress Queries – Removing Group By ID
- How can I combine one field using wpdb and group by?
- $wpdb->prepare with ON DUPLICATE KEY UPDATE
- how to use $wpdb->prepare to update a custom table
- WPDB Placeholders and second argument for prepared statements
- Increment integer field in database when WHERE needs to be dynamic [closed]
- Custom SQL query ORDER BY term_order
- Custom $wpdb returns unexpected time based results
- How to left join meta in queries [closed]
- wpdb->get_row is selecting the variable as a column name
- CREATE TABLE with dbDelta does not create table
- $wpdb query outputs php code instead of executing it
- wpdb query not working
- WordPress wpdb->insert returns int(0) => doesn’t insert anything, no errors!
- WPDB SQL Ignore `post_status` Parameter
- how to list all post that are in the custom taxonomy using $wpdb
- WPDB SQL query SELECT from category
- How to use WHERE NOT EXISTS query to avoid duplicate entry using $wpdb to save in custom table?
- Creating an Angular factory from custom database table
- wpdb->update update the entire table instead of one row
- How do I update post based on meta_key in another table?
- How to set up prepared query using IN statement
- Custom database query to validate data
- Alter the main search query to search posts by coauthor user name
- Creates only one table and not the other
- Protect custom form from SQL injection
- looking for a way to allow users to backup the plugin db data(save as)
- SQL Query to select post title & post ID from a particular category
- Get comments after specific date
- query using wpdb in wordpress gets me no result
- Get count of rows based if column exists in two different tables
- query_vars doesn’t return query string (trying to get data from $wpdb)
- How does wordpress link columns from different tables without using FOREIGN KEY or JOIN?
- How do you properly prepare a %LIKE% SQL statement?
- $wpdb->get_row() only returns a single row?
- WPDB Insert or if exists Update
- wpdb->insert: do I need to prepare against SQL injection?
- How to parse row results from $wpdb -> get_results
- Why $wpdb->show_errors() and print_error() is showing an output even if the query output is correct?
- what is the way to see the currently executing query in wordpress?
- Fetch array with $wpdb
- How do I check for a duplicate record before inserting using wpdb
- Pagination with custom SQL query
- WordPress 4.8.1 uses mysql_connect which doesn’t work with PHP 7
- $wpdb->insert not working in any way
- WPDB prepare – like % – placeholders?
- $wpdb->update multiple rows, like IN in normal SQL
- Matching database content types to PHP types
- $wpdb->get_results(…) returns empty array despite correct query
- Does $wpdb->prepare not create a prepared statement that I can execute multiple times?
- Use wpdb->prepare for `order by` column name
- $wpdb->insert() and Values for Datetime Columns?
- SELECT max(meta_value) FROM wp_postmeta WHERE meta_key=’price’… stops working when value is over 999
- How to Use Wildcards in $wpdb Queries Using $wpdb->get_results & $wpdb->prepare?
- $wpdb->last_error doesn’t show the query on error
- wpdb get posts by taxonomy SQL
- Avoiding “Usage of a direct database call is discouraged”
- Display data from a non wordpress database on a page template
- wpdb->prepare function remove single quote for %s in SQL statment
- dbDelta does not create Table, but returns success
- Theoretical Multi-Server WordPress Setup with Shared Users
- Multipart/formatted MySQL query problem
- Change post status based on meta value
- prepare() not working
- wpdb->insert not working
- Saving custom form data into database
- Inserting Post Meta From SQL
- Retrieving custom fields with $wpdb->get_results
- How to make an activities stream mixing posts and comments?
- passing variables as parameters to stored procedures via wpdb from php-script
- Get data from database table by post_id to get data from second database table
- wp-content/db.php : where is this file?
- Getting users who registered 360 days from current date
- Querying Email Addresses for a List of Users with Same Last Name?
- Quotes in table name
- Delete/replace img tags in post content for auto published posts [closed]
- $wpdb sql help. Select post id and post meta value based on 2 other post_meta values
- $wpdb->get_results() returns good result only in first foreach iteration
- $wpdb->insert – inserting multiple rows
- Speed optimization of $wpdb->get_results
- How do I create a single.php for a specific category?
- $wpdb prepared with search term
- Really simple query giving error in SQL syntax
- WPDB->insert with special characters
- What does wp_update_post() do that the $wpdb class does not?