Here you go (you’re really close): INSERT INTO wp_postmeta (post_id, meta_key, meta_value) SELECT ID AS post_id, ‘customer_reviews’ AS meta_key, ‘On_or_delete’ AS meta_value FROM wp_posts WHERE wp_posts.post_content LIKE ‘%Customer Reviews%’ AND wp_posts.post_type=”post”; ` Edit: You could also just change IS IN to IN. I rewrote the from part of the query since a subquery was unnecessary … Read more
My guess is that this is the wrong hook for what you are trying to do, or you are using it incorrectly. A few notes: You are passing unvalidated data into a query. Please don’t do that. This… $town_b = $_POST[‘item_meta’][800];//Gets the value from the first field global $wpdb; $query = “SELECT County FROM wp_locations … Read more
And I want to add an additional condition that the post be in a specific category. Any thoughts? JOINing on the taxonomy tables is complicated. Unless you have a good reason why you have to use SQL, don’t. Use WP_Query. $args = array( ‘post_type’ => $holder, ‘numberposts’ => -1, ‘post_status’ => array(‘publish’), ‘category_name’ => ‘cat-slug’, … Read more
the part ORDER BY $orderby $order LIMIT get translated to ORDER BY asc LIMIT, the columnname that supose to be in $orderby is missing, and there for the sql fail. looks like you want your default value to be ‘title’ $orderby = (isset($_REQUEST[‘orderby’]) && in_array($_REQUEST[‘orderby’], array_keys($this->get_sortable_columns()))) ? $_REQUEST[‘orderby’] : ‘title’; may geuss is that in_array() … Read more
In general – Yes. Make sure that the file and directory permissions are appropriate. In case the URL of your website changes, you would have to do a find/replace. Read more about it in the links below. Also, ‘update permalinks’ once you have access to the Dashboard. References: Codex: Moving WordPress Codex: Changing File Permissions … Read more
I guess one could argue that this is somewhat wordpress related, because you are trying to get_results() from $wpdb, but like @MarkKaplun said your problem is that you are using the SQL wrong. Below code is an example on how to do it correct: $dr = $wpdb->get_results( $wpdb->prepare( “SELECT * FROM wp_shipping WHERE country = … Read more
You do not need to be messing with the database connection. WordPress provide a database object called $wpdb. It is not really clear what you are doing. Your title reads “help me select thumb”, but your code is actually pulling a lot of different post statuses, not thumbnails. In fact, your code does not have … Read more
You’re recreating the select element on every iteration through the loop, and you need to name your current loop assignment variable differently, as you’re overwriting your original. Lastly, you’re also not assigning a value to the options within the loop, so you’re not going to get anything on the form submission, and text isn’t a … Read more
That query is run in the get_comment_count() function in core. The wp_count_comments() function runs a similar query, but it caches the resulting data using the wp_cache system (so it won’t run that code more than once per request). get_comment_count() does not use the cache. Thing is, this seems to me to be a perfectly a … Read more
$args=array( ‘orderby’ => ‘rand’, ‘order’ => ‘DESC’, ‘posts_per_page’ => 3, ‘offset’ => $offset, ); $q = new WP_Query($args); if($q->post_count>0){ $random_post = $q->posts[mt_rand(0,2)]; } also, just a little note, ORDER BY RAND() is pretty bad for performance