selecting data from 2 tables

[eluser]Bigil Michael[/eluser]
when i change year and constituence
result print like this


string(167) "SELECT * FROM (`candidate_details`) WHERE `constituency_id` = '1' AND `elect_year` = '2011' AND `candidate_votes` = (SELECT MAX(candidate_votes)FROM candidate_details)" array(0) { }