Sarah_Frantz

NVM solved myself.

For those who need it, the following will find all posts by author, then sum up the values of a custom field for each post by that author.

<?php
			//get current user
			global $current_user;
		    get_currentuserinfo();
			// build query of ids by user
			$userPosts = get_posts(array('author' => $current_user->ID, 'post_type'=> 'miles')); //change this
			// loop to create array of ids by user
			foreach ($userPosts as $post) {
			    setup_postdata($post);
			    $ids[] = get_the_ID();
			}
			$idList = implode(",", $ids); //tun this crap into a list

			$meta_key = 'miles';//set this to your custom field meta key
			$allmiles = $wpdb->get_col($wpdb->prepare("
			                                  SELECT meta_value
			                                  FROM $wpdb->postmeta
			                                  WHERE meta_key = %s
			                                  AND post_id in (" . $idList . ")", $meta_key));
			echo '<p>You\'ve completed ' . array_sum( $allmiles) . '</p>';	?>

The brands are more like categories than tags… would it still work the same?

Is there a way to avoid redundancy?

For example, let’s say I have a product that is for ages birth to 12 months, and under $25 AND is brand XYZ, it would appear:

Birth to 12 Months
– XYZ Brand
–Product

Under $25
– XYZ Brand
–Product

Wouldn’t that be redundant? How do you avoid this?

Or maybe I just do multiple custom taxonomies, and not do drill downs of one category.

I will be sure to update my query, however any insight in avoiding duplicate posting across the sections would be much appreciated.

perm=readable only gathers posts that are not marked private

here is more from that code, with showposts replaced.

pastebin

RESOLVED. Moved orderby above post type and it works like a charm.

I switched it to check for a yes or no and display based on that, which seems to be working now to only show articles with the quote, however it isn’t randomizing it..

$args = array(
	'post_type' => 'knowledgebase',
	'orderby' => 'RAND',
	'showposts' => 1,
	'meta_query' => array(
		array(
			'key' => 'show_quote?',
			'value' => 'Yes'
		)
	)
);
$quotequery = new WP_Query( $args );

I guess I forgot to mention I’m using Advanced Custom Fields, so the field is a custom field value, and it is always present…

Ah, I think I solved this. nvm.

Thats what I ended up doing, a css approach. Only problem is it seems like handing off something like that to the next developer whoever handles the site might be confused by it all.

Thanks, I actually just got it solved before I saw this – but ended up doing something a little different. This looks much cleaner than my code though haha

Also, how would you display the resulting average?

Would I do something like this for my query?

SELECT AVG(wp_commentmenta.meta_value)
FROM wp_commentmeta, wp_comments
WHERE wp_commentmeta.comment_ID = wp_commnets.comment_ID
AND wp_comments.comment_post_id = $post->ID
AND wp_comments.meta_key = 'performance'