chamilo / chamilo-lms

                    ";

            $result = Database::query($sql);

            while ($row = Database :: fetch_array($result)) {

                $answer_list['value'] = $row['value'];

                $answer_list['group'] = $row['survey_group_pri'];

                $results[] = $answer_list;

            }

            //echo '<br />'; print_r($results); echo '<br />';

            // Get the total score for each group of questions

                    ORDER BY temp.survey_group_pri";

            $result = Database::query($sql);

            while ($row = Database::fetch_array($result)) {

                $list['value'] = $row['value'];

                $list['group'] = $row['survey_group_pri'];

                $totals[] = $list;

            }

            //echo '<pre>'; print_r($totals);

            $final_results = array();

                GROUP BY option_id, value";

        $result = Database::query($sql);

        $number_of_answers = 0;

        while ($row = Database::fetch_array($result)) {

            $number_of_answers += $row['total'];

            $data[$row['option_id']][$row['value']] = $row;

        }

        $chartData = array();

        foreach ($options as $option) {