plbarrett2004

Yes that’s correct. The category ID for the example is 3.

Ok, so the problem was definitely the plugin. By using the default custom field entry ‘shop_hours’ in posts, I am able to get the appropriate behavior. The total is working properly. I finally cleaned up my code, and my next thought is to implement the same code by category. I don’t think I can use the current select statement to do so though… any thoughts?

/*
The following functions will be used to total all session hours by post
using the custom field 'shop_hours'
Subsequent functions will work for specific categories.
*/

// Function totals all session hours
function total_hours() {
    global $wpdb;
    $total_hours=0;
    $meta_key = 'shop_hours';//set this to your custom field meta key
    $allhours=$wpdb->get_col($wpdb->prepare("SELECT meta_value FROM $wpdb->postmeta WHERE meta_key = %s", $meta_key));
    foreach ($allhours as $hours) {
            $total_hours = $total_hours + $hours;
    }
    return $total_hours;
}

// Total of all hours by category
// Total hours for empennage (cat id = 3)
function emp_hours() {
    global $wpdb;
    $emp_hours=0;
    $meta_key = 'shop_hours';//set this to your custom field meta key
    $allhours=$wpdb->get_col($wpdb->prepare("SELECT meta_value FROM $wpdb->postmeta WHERE meta_key = %s", $meta_key));
    foreach ($allhours as $hours) {
        $emp_hours = $emp_hours + $hours;
    }
    return $emp_hours;
}

// Shortcodes for all hour total functions
add_shortcode('total-hours','total_hours'); // Total
add_shortcode('emp-hours','emp_hours'); // Empennage (cat id = 3)

The extra lines are from me being sloppy with my code insert… added some extra line breaks to keep myself straight.

I thought that would do it, but…

Notice: Undefined variable: sum in /var/www/papalimabravo.com/public_html/wp-content/themes/twentyeleven/functions.php on line 46
float(1040.25)

I only included the first part of the output, as there is quite a long output. Let me know if you need more output. I appreciate your help!!!

-Peter

Also my website is at http://www.papalimabravo.com.

Thanks Sam. I am now able to get the code to work, but another error is occurring.

The sum is not matching the data. It seems that data is sometimes double counted, or if changed, not deleting / overwriting but appending.

Here is my code that has been added to functions.php in my twenty eleven theme.

function total_hours(){
    global $wpdb;
    unset($hours);
    $hours = array();
    $meta_key = 'session_duration';//set this to your custom field meta key
    $hours = $wpdb->get_col($wpdb->prepare("SELECT meta_value FROM $wpdb->postmeta WHERE meta_key = %s", $meta_key));
    return array_sum($hours);
}
add_shortcode('total-hours','total_hours’);

Here is an example of the performance I am seeing with the short code [total-hours]

989.25 and then I add a custom field entry of 10, and save. The new total-hours = 1009.25. Now, I remove the 10 hours field entry, and the total hours becomes 999.25. It double counts on the initial entry, but removes the correct amount. Meaning the total becomes more and more incorrect with each entry and or change.

session_duration is a float. All values are one decimal precision. (Ie; 1.0, 5.5, etc) The number represents hours.