Welcome Guest, Not a member yet? Register   Sign In
countvotes
#1

[eluser]benfike[/eluser]
Hi!

How can I count the answer for the votes_answers?

votes_votes table structure:
id
ansid - answer id
voteid - the poll id
userid - userid
Code:
function countVotesByAnsId($id){
        $this->db->where('ansid',$id);
        $data = '+';
        $Q = $this->db->get('votes_votes');
        if($Q->num_rows() > 0){
            $data = $Q->num_rows();
        }
        $Q->free_result();
        return $data;
    }
Whats the problem with that code?

Now only count the first Answer, answers.
#2

[eluser]benfike[/eluser]
the rsult view:
Code:
<?php foreach($answers as $answer):?>
<?
$szavazat=$szavazat;
$atlag=$szavazat;
?>

                    <strong><p>&lt;?php echo ($answer['answer']) ?&gt;</p></strong>
                    &lt;? print "<img >"; ?&gt;
                    szavazatok száma &lt;?php echo $szavazat;?&gt;<br />
            &lt;?php
            endforeach;
            ?&gt;

here is the $szavazat = that function




Theme © iAndrew 2016 - Forum software by © MyBB