spires Posted November 20, 2010 Share Posted November 20, 2010 Hi I want to know I can select which ID I get from an inner join? Not sure If I should post here or in the MYSQL forum, but as it's using OOP I posted here. $sql = "SELECT * FROM area_county INNER JOIN area_country "; $sql .= "ON area_county.country_id = area_country.id "; $sql .= "ORDER BY area_country.country, area_county.county ASC "; $sql .= "LIMIT {$per_page} "; $sql .= "OFFSET {$pagination->offset()}"; $list = Area_county::find_by_sql($sql); foreach($list as $lists){ $ID = $lists->id; $country_id = $lists->country_id; $county = ucwords($lists->county); $country = ucwords($lists->country); echo $ID; } I want it to show the ID of the county, NOT the id of the country. both tables in the database have the ID column called id. I know this can be done, but not to sure how. Thanks Link to comment https://forums.phpfreaks.com/topic/219286-inner-join-used-in-oop/ Share on other sites More sharing options...
spires Posted November 20, 2010 Author Share Posted November 20, 2010 Query need to be the other way around: $sql = "SELECT * FROM area_country INNER JOIN area_county "; $sql .= "ON area_country.id = area_county.country_id "; $sql .= "ORDER BY area_country.country, area_county.county ASC "; $sql .= "LIMIT {$per_page} "; $sql .= "OFFSET {$pagination->offset()}"; $list = Area_county::find_by_sql($sql); Link to comment https://forums.phpfreaks.com/topic/219286-inner-join-used-in-oop/#findComment-1137132 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.