So I added permissions for my $mydb user to have SELECT priviledges to my WordPress database. I then used this code to perform the JOIN: $sql=”SELECT * FROM `mydb`.`records` rec LEFT JOIN `wpdb`.`wp_users` usr ON rec.`mydb`=usr.`ID`”; $records = $mydb->get_results($sql, ARRAY_A); Worked great!
Here’s the solution: global $wpdb; $wpdb->get_results( $wpdb->prepare( “SELECT tags.*, COUNT(tags_rel.object_id) as posts_count FROM {$wpdb->prefix}terms tags INNER JOIN {$wpdb->prefix}term_taxonomy tags_tax ON (tags_tax.term_id = tags.term_id) INNER JOIN {$wpdb->prefix}term_relationships tags_rel ON (tags_tax.term_taxonomy_id = tags_rel.term_taxonomy_id) INNER JOIN {$wpdb->prefix}posts posts ON (tags_rel.object_id = posts.ID) INNER JOIN {$wpdb->prefix}term_relationships cats_rel ON (posts.ID = cats_rel.object_id) INNER JOIN {$wpdb->prefix}term_taxonomy cats_tax ON (cats_rel.term_taxonomy_id = cats_tax.term_taxonomy_id) … Read more
Sounds like your expires headers are set to far in the future. The following rules can be added to your .htaccess Expires rules can be added to your Nginx server file to shorten the expires time down to 180 seconds. location ~* \/[^\/]+\/(feed|\.xml|.html|.HTML)\/? { expires 180; } I would also suggest installing the Nginx Proxy … Read more
<?php $querystr = ” SELECT wposts.* FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta WHERE wposts.ID = wpostmeta.post_id AND wpostmeta.meta_key = ‘date_field’ AND wpostmeta.meta_value=”03/11/2010″ AND wposts.post_status=”publish” AND wposts.post_type=”post” ORDER BY wposts.post_date DESC “; $pageposts = $wpdb->get_results($querystr, OBJECT); ?> Then you would access $pageposts as an object
Instead of a JOIN, you can use a IN with a subquery, to prevent duplicate results because of the join: SELECT ID, display_name FROM wp_users WHERE ID IN (SELECT post_author FROM wp_posts) This will not look at capabilities. If you also want that you can add them like a join, but move the meta_key clause … Read more
you need to get the ID back from your post insertion and use that with add_post_meta: $post_id = wp_insert_post($post); add_post_meta($post_id, ‘thumbnail’, $yourvalue, true);
You probably messed up with the config on the DB I would like the dump of the config table please, that way i can see the paths to your wp install (i had a similar problem which i solved by manually correcting the fields in DB) EDIT Run this sql query and let me know … Read more
Does the unused postmeta affect the speed of my database? Anything in your database affects the speed of your database. The question is how much of a slowdown, and if the amount of data is significant enough. Unless your having a huge amount of metadata it will not affect the speed of your database very … Read more
You could use the wp_dropdown_categories() function and pass post_tag as taxonomy parameter. <?php wp_dropdown_categories( array( ‘taxonomy’ => ‘post_tag’ ) ); ?>
I would suggest inserting your tours as posts (or custom posts) and using a custom reference table with the id matching the post id of the Tour post. You could use WordPress’s built in meta box functions to be able to edit each Tour in the edit posts page. You could update your reference table … Read more