First i have to say...this is the best software for survey....this help me so many times in my work
Congratulations Johns .... ^.^

i make some modifications on SELECT (retrieve answers to questions) on class “results.class.php”...all fine....but now i want to know, if possible, how can i sum and show the Total....
It's dificult to explain but i want some thing like this....


I know....i know....have one “Total Answer” but when i use my kind of SELECT some answered surveys are “omited”....and the Total show me all the answers... i want only the Total results for my SELECT, not all answer.....

What kind of modifications did you make? The total should just count up how many rows were returned for each question ID.

i add some column to table results and change the SELECT.....

SELECT r.qid, r.avid, count(*) AS c FROM {$this->CONF['db_tbl_prefix']}results r,
{$this->CONF['db_tbl_prefix']}answer_values av,
{$this->CONF['db_tbl_prefix']}questions q, site.contact
WHERE r.qid = q.qid and r.sid = $sid and r.avid = av.avid and contact.status = 1 and
r.status = contact.status $hide_show_where
{$_SESSION['filter'][$sid]}
GROUP BY r.qid, r.avid
ORDER BY r.avid ASC



but it returns all the answers for each question....ignoring my select

the {$count[qid][a]}....OK for each row
but {$num_answers[qid]} return all

how can i sum using {$count[qid][a]}?