[wp-hackers] WP 3.5.2/multisite: How to use NOT IN in $wpdb->prepare()?
mickyhulse.lists at gmail.com
Tue Jul 16 02:36:21 UTC 2013
Situation and example code:
$ignore = implode(',', array('1', '19', '21',));
$rows = $wpdb->get_results($wpdb->prepare("SELECT blog_id FROM
$wpdb->blogs WHERE blog_id NOT IN (%s) AND public = '1' AND archived =
'0' AND mature = '0' AND spam = '0' AND deleted = '0'", $ignore),
The "NOT IN ()" filter fails to ignore blog ids.
I'm not certain, but I assume my code fails because $ignore isn't of
the %s, %d or %f types.
Move $ignore into the statement like so:
... blog_id NOT IN ($ignore) ...
I get this PHP notice:
PHP Notice: wpdb::prepare was called <strong>incorrectly</strong>.
wpdb::prepare() requires at least two arguments. Please see <a
WordPress</a> for more information. (This message was added in version
3.5.) in /rgblog/html/wp-includes/functions.php on line 2962
Reason for the notice:
"PHP Warning: Missing argument 2 for wpdb::prepare()"
you’re passing $id directly into the query, unprepared. And this,
right here, is why $wpdb->prepare() now issues a warning if it isn’t
called with more than one argument. Because you can’t prepare a query
without more than one argument.
With that said, how can I accomplish my goal of passing several blog
IDs into a query that uses wpdb::prepare() (like my example above)?
Any tips would be appreciated. :)
More information about the wp-hackers