The $wpdb class properties You can use all the default WordPress tables like this: $GLOBALS[‘wpdb’]->postmeta so no need to use prefix, etc. meta_query As you can see from the Custom field parameter documentation, there’s nothing like the <> (or in other words: “not equal to”) operator. The equivalent operator in WP should be != (human … Read more
is this what you’re after? Using the “Relation” for the Meta Query, you can select multiple Meta Keys. You can change the “Compare” to any of the operations available for that function. (From the Codex) compare (string) – Operator to test. Possible values are ‘=’, ‘!=’, ‘>’, ‘>=’, ‘<‘, ‘<=’, ‘LIKE’, ‘NOT LIKE’, ‘IN’, ‘NOT … Read more
How to display users with posts published between two dates (Sorted by Post-Count) [Multisite]
In general, I’d recommend to read about $wpdb in detail in the Codex. Some notes: Never use the default wp_ prefix. Never set a hard coded prefix. It will be set during installation and should later be added using $wpdb->prefix. But: Prefixes can be changed with the following SQL command. “RENAME table wp_posts TO {$wpdb->prefix}posts;” … Read more
wpdb updating record in wordpress with json adds extra array elements
Query most popular terms by taxonomy over 2 week period
Code only works every other time its run
This is what I ended up using, turned out I didn’t need to apply the meta value to the child pages since I used another approach. Hopefully it’s useful for someone. $row = $wpdb->get_row(“SELECT * FROM wp_posts WHERE ID =’$post_id'”); $new_order = $order[$page[‘depth’]]; $new_order = $wpdb->escape($new_order); $current_order = $row->menu_order; if($current_order != $new_order) { switch ($new_order) … Read more
global $wpdb; /* grab meta value, it is assumed you know the post id ($id) in question */ $dot_number = get_post_meta( $id, ‘dot_number’, true ); /* grab all rows with matching value in ‘dot_number’ column */ $matches_query = $wpdb->get_results( “SELECT * FROM ” . $wpdb->prefix . “csadata ” . “WHERE dot_number = ” . $dot_number, … Read more
Changing status of Published posts which have less Content to “Draft”