CodeIgniter Forums

Full Version: countvotes
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

[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.

El Forum

[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