I’ve solved the problem myself though it is probably not be the right way to do it. Note that I’ve had to type “website-address” instead of the actual URL because system here won’t let me use more than one URL in a post without more reputation. That makes it quite difficult to convey what’s actually … Read more
Retrieve post data via WPDB class
The problem here is the LIMIT, it’ll just count the first page and not the entire query. I had solved it by providing a secondary SQL query for counting the max pages. thanks for my friends for this tip. here’s the complete code. function.php function spiciest(){ global $wpdb, $paged, $max_num_pages; $paged = (get_query_var(‘paged’)) ? get_query_var(‘paged’) … Read more
Got the idea from this post to change my query : How to “orderby” the first array in a meta_query that uses multiply keys? I moved the state query into the larger array of queries, freeing the ‘meta_key’ value to be assigned to event date $args = array( ‘post_type’ => ‘tf_events’, ‘meta_query’ => array( $relation, … Read more
This is possible, but there’s not a “neat” way to do it. There’s a great write-up here: Display the Most Recent Post in Each Category but as the author points out, it’s a separate query to get the most recent posts for each term. To his great credit, he does deal with caching them, which … Read more
You can use $args = array( ‘post_type’ => ‘post’ ,’posts_per_page’ => 10, ‘category_name’ => ‘orange’ ); $query = new WP_Query( $args ); printf( ‘<h2>Generated SQL:</h2><pre>%s</pre>’, $query->request ); to display the generated SQL query. The above example will give you: <h2>Generated SQL:</h2> <pre> SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE … Read more
Your Query is wrong beacuse your are searching for the user_id inside the meta_value column instead of the user_id column. In this case i see no point in creating a custom query just for that, So here is how you can do it using the native function get_user_meta $data = get_user_meta( get_current_user_id(), ‘bookmark_posts’ ); $number … Read more
This will work fine. global $wpdb; $querydetails = ” SELECT wposts.* FROM $wpdb->posts AS wposts INNER JOIN $wpdb->postmeta AS wpostmeta ON wposts.ID = wpostmeta.post_id WHERE wposts.post_status=”publish” AND wposts.post_type=”match_report” AND wpostmeta.meta_key = ‘report_home-select’ AND wpostmeta.meta_value=”198″ “; $teaminfo = $wpdb->get_results($querydetails, OBJECT); Try it.
Error inserting row into table
From technical perspective wpdb->prepare() essentially trickles down to escaping variables with either (depending on configuration) mysql_real_escape_string() or addslashes(). It’s not inherently more or less secure than any other properly implemented escaping routine. It is closer to specifics of WP and configuration it is aware off.