select maximum problem

[eluser]Bigil Michael[/eluser]
can anyone help me?????

model

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();

controller

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

view

<?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

}
?>

i want to print constituency name and winner name for any purticular year
but it prints only one result.
can anyone help me?
urgent.....
any help/suggestions ?????
thanks in advance...