Well, after looking at the other tables I had created successfully, only difference was the description column. Apparently WordPress or MySQL doesn’t like that as a column name and somehow has it reserved. So, after renaming it, the table was created fine. Hope this helps someone else in the same boat.
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