problem in finding second maximum value

[eluser]John_Betong_002[/eluser]
Try this:

Code:

$sql=
"
  SELECT *
  FROM   candidate_details WHERE elect_year = ‘2005’ And constituency_id = ‘1’
  ORDER BY candidate_votes
  DESC
  LIMIT    1,1
";
$query = $this=>db->query($sql);

if($query->num_rows() > 0)
{
  $row = $query->row();

  // display results
  echo '<pre>';
    print_r($query->row());
  echo '</pre>';
}

EDIT: spelling