Quote:function select_can($elect_year)
{
$result_category = $this->db->query("SELECT con.constituency_name, con.elect_year, con.constituency_id, con.total_voters, con.total_polled ,can.candidate_name, can.candidate_votes FROM constituency_details AS con, candidate_details AS can WHERE can.constituency_id = con.constituency_id AND can.elect_year = $elect_year AND con.elect_year = $elect_year AND candidate_votes = (SELECT MAX(candidate_votes)FROM candidate_details WHERE elect_year=$elect_year)"
);
return $result_category->result_array();

Quote:$this->data['can'] = $this->Election_result_model->select_can($elect_year);

Quote: <?php
foreach ($can as $lrow)
{
?>
<?php echo $lrow['constituency_name'];?>
<?php echo $lrow['total_polled'];?>
<?php echo $lrow['candidate_name'];?>
<?php echo $lrow['candidate_votes'];?>
<?php

}
?>