When you look at the Codex article on $wpdb, then you will see that your current usage is correct. The last argument array( ‘%s’, ‘%d’, ‘%s’ ) already indicates that there is something like sprintf/printf going on in the background. The $wpdb->prepare() method isn’t needed for every other method. The ones that need it: $wpdb->query() … Read more
Is there a WP function to get taxonomy name from taxonomy_term_id?
It’s my fault. Got the solution after @Otto’s comment: Do you actually have a duplicate key here? What is the structure of user_req and what are the keys and indexes? Here’s how my SQL query should be: INSERT INTO {$wpdb->prefix}user_req ( user_id, post_id ) VALUES ( %d, %d ) WHERE NOT EXISTS ( SELECT * … Read more
How to query custom post types with mixed AND & OR statements for custom fields
wpdb custom tables without plugin
Codex: Database Description: meaning of Cardinality
Use get_results(‘SELECT * FROM wp_aacv WHERE post_title LIKE ‘”.$abcde.”‘ ‘);
Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
If you want best practices of the options you listed use the user meta table. Adding a column to the users table would be the worst thing you could do – messing with table structure of default WP tables is a no-no. The other two options would fall somewhere in between – with adding your … Read more
$wpdb->insert running multiple times?