Function Reference: geodir_get_review_total

Summary

Get review total of a Post.

Description

Returns review total of a post. If no results returns false.

Global Values

$wpdb

(object) (required) WordPress Database object.

Default: None

Package

GeoDirectory

Parameters

$post_id

(int) (required) The post ID.

Default: None

Return Values

(bool|null|string)

Change Log

Since: 1.0.0

Source File

geodir_get_review_total() is located in geodirectory-functions/comments_functions.php [Line: 558]

Source Code

function geodir_get_review_total($post_id = 0)
{
    global $wpdb;

    $results = $wpdb->get_var(
        $wpdb->prepare(
            "SELECT SUM(overall_rating) FROM " . GEODIR_REVIEW_TABLE . " WHERE post_id = %d AND status=1 AND overall_rating>0",
            array($post_id)
        )
    );

    if (!empty($results))
        return $results;
    else
        return false;
}