selecting data from 2 tables

[eluser]Bigil Michael[/eluser]
can any one help me the problem is "resut repeating".

my tables

table name: constituency_details


id constituency_name constituency_id elect_year

1 vattiyoorkavu 4 2010
2 parassala 1 2011
3 neyyattinkara 2 2011
8 nemom 9 2008

tablename:candidate_details

id constituency_id candidate_name candidate_party elect_year

1 2 Selvaraj CPM 2011
2 4 babu incu 2010
4 1 George INC 2011
5 1 Nagappan CPM 2011
6 1 Suresh BJP 2011
7 2 Ravi INC 2011
8 2 sajith BJP 2011

my controller

function index($pgoffset='')
{
$config['per_page'] = 9;

$this->data['pagetitle'] ='Election Results';

$build_array = array();
$fleets = $this->Election_result_model->select_constituency($config['per_page'], $pgoffset);

foreach($fleets as $row){
$build_array[] = array (
'fleets_array' => $row,
'listefleets_array' => $this->Election_result_model->list_constituency($row['constituency_id'])
);
}
$this->data['meow'] = $build_array;

$this->load->view('election_result',$this->data);
}

model

function select_constituency($limit=NULL, $pgoffset=NULL)
{
$sql = "SELECT constituency_details.constituency_name, constituency_details.elect_year, constituency_details.constituency_id FROM constituency_details JOIN candidate_details ON (candidate_details.constituency_id = constituency_details.constituency_id AND candidate_details.elect_year = constituency_details.elect_year) ORDER BY constituency_details.constituency_name";

$query = $this->db->query($sql);
return $query->result_array();
}

function list_constituency($cid)
{
$this->db->where('constituency_id',$cid);
$this->db->order_by('candidate_name');
$result_product = $this->db->get('candidate_details');
return $result_product->result_array();
}

view

<div id="t1">

&lt;?php
foreach ($meow as $crow)
{ ?&gt;
<div id="t2">
<div style="padding-bottom:10px; font-size:14px;">&lt;?php echo $crow['fleets_array']['constituency_name'];?&gt; &nbsp;&nbsp;&nbsp;&lt;?php echo $crow['fleets_array']['elect_year'];?&gt; </div>

&lt;?php
foreach ($crow['listefleets_array'] as $lrow)
{
?&gt;
<p>&lt;?=$lrow['candidate_name'];?&gt;</p>
<p>&lt;?= $lrow['candidate_party'];?&gt;</p>
<p>&lt;?= $lrow['candidate_votes'];?&gt; </p>
<p>&lt;?= $lrow['percentage_votes'];?&gt;</p>
&lt;?php
}
?&gt;
</div>
&lt;?php
}
?&gt;

</div>

it is working but result is repeating
result like this

neyyattinkara 2011

Ravi

INC

879879

20

sajith

BJP

7878

5

Selvaraj

CPM

123456876

75
neyyattinkara 2011

Ravi

INC

879879

20

sajith

BJP

7878

5

Selvaraj

CPM

123456876

75
neyyattinkara 2011

Ravi

INC

879879

20

sajith

BJP

7878

5

Selvaraj

CPM

123456876

75

can anyone help me
i dont know how to remove this problem
urgent.......

thanks in advance.......