Welcome Guest, Not a member yet? Register   Sign In
selecting data from 2 tables
#18

[eluser]Bigil Michael[/eluser]
one more help please

my table
Quote:id constituency_id candidate_name candidate_votes elect_year

1 2 Selvaraj 123456876 2011
2 4 kk 4678 2010
4 1 George 75 2011
5 1 Nagappan 15 2011
6 1 Suresh 5 2011
7 2 Ravi 20 2011
8 2 sajith 5 2011
10 1 sssssss 11111 2010

i want to select cndidate name who has max:candidate votes
i searched but i didn't get result

code me used is
Quote:function select_win()
{
this->db->select('candidate_name');
$this->db->select_max('candidate_votes');
$result_product = $this->db->get('candidate_details');
return $result_product->row_array();
}

it prints maximum votes
not candidate votes
i want the candidate name
can u help me??
thanks in advance........


Messages In This Thread
selecting data from 2 tables - by El Forum - 04-16-2011, 12:43 AM
selecting data from 2 tables - by El Forum - 04-16-2011, 01:00 AM
selecting data from 2 tables - by El Forum - 04-16-2011, 01:09 AM
selecting data from 2 tables - by El Forum - 04-16-2011, 01:24 AM
selecting data from 2 tables - by El Forum - 04-16-2011, 01:30 AM
selecting data from 2 tables - by El Forum - 04-16-2011, 01:49 AM
selecting data from 2 tables - by El Forum - 04-16-2011, 02:21 AM
selecting data from 2 tables - by El Forum - 04-16-2011, 03:24 AM
selecting data from 2 tables - by El Forum - 04-16-2011, 03:46 AM
selecting data from 2 tables - by El Forum - 04-16-2011, 03:48 AM
selecting data from 2 tables - by El Forum - 04-16-2011, 04:03 AM
selecting data from 2 tables - by El Forum - 04-16-2011, 04:07 AM
selecting data from 2 tables - by El Forum - 04-16-2011, 04:15 AM
selecting data from 2 tables - by El Forum - 04-16-2011, 04:23 AM
selecting data from 2 tables - by El Forum - 04-16-2011, 04:41 AM
selecting data from 2 tables - by El Forum - 04-16-2011, 04:51 AM
selecting data from 2 tables - by El Forum - 04-16-2011, 04:52 AM
selecting data from 2 tables - by El Forum - 04-16-2011, 05:09 AM
selecting data from 2 tables - by El Forum - 04-16-2011, 05:56 AM
selecting data from 2 tables - by El Forum - 04-16-2011, 06:12 AM
selecting data from 2 tables - by El Forum - 04-16-2011, 06:25 AM
selecting data from 2 tables - by El Forum - 04-16-2011, 06:33 AM
selecting data from 2 tables - by El Forum - 04-16-2011, 06:38 AM
selecting data from 2 tables - by El Forum - 04-16-2011, 06:47 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 12:34 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 12:44 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 12:51 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 01:01 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 01:03 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 01:07 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 01:09 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 01:10 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 01:17 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 01:23 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 01:29 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 01:38 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 01:45 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 02:28 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 02:40 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 02:45 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 03:04 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 03:11 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 03:15 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 03:16 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 03:22 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 03:23 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 03:25 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 03:31 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 03:33 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 03:53 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 04:52 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 05:09 AM
selecting data from 2 tables - by El Forum - 04-18-2011, 10:44 PM
selecting data from 2 tables - by El Forum - 04-19-2011, 06:11 AM



Theme © iAndrew 2016 - Forum software by © MyBB