Sum вывод в php?

Question

[Сергей Дефактов]

пытаюсь вывести sum на экран с бд , вроде все правильно составлено но ничего не выводит , подскажите вчем проблема

function Wo_FeaturedUsers($limit = '', $type = '')
{
    global $wo, $sqlConnect;
    if ($wo['loggedin'] == false) {
        return false;
    }
    $data = array();
    $logged_user_id = $wo['user']['user_id'];
    $sql = mysqli_query($sqlConnect, $query_one);
   {
        $query_one = " SELECT `user_id`, SUM(views)
FROM `Wo_Posts`
WHERE `time` >= DATE_SUB( CURRENT_DATE, INTERVAL 90
DAY ) AND page_id = 0 GROUP BY `user_id`
ORDER BY  SUM(`views`) DESC LIMIT 30
";
        $sql = mysqli_query($sqlConnect, $query_one);
        while ($fetched_data = mysqli_fetch_assoc($sql)) {

$data[] = Wo_UserData($fetched_data['user_id']);
echo $fetched_data['SUM(views)'];
        } 
    } 
    return $data;
}

Comments

[Ислам Киясов]

SELECT `user_id`, SUM(views) as sum
FROM `Wo_Posts`
WHERE `time` >= DATE_SUB( CURRENT_DATE, INTERVAL 90
DAY ) AND page_id = 0 GROUP BY `user_id`
ORDER BY  SUM(`views`) DESC LIMIT 30

$fetched_data['sum']

Answer 1

[Вадим]

Возможно $fetched_data['my_sum']; ?