Anonymous

	$query = "SELECT members.*, country.id, country.country, state.id, state.state, city.id, city.city, region.id, region.region FROM members LEFT JOIN (country, state, city) ON (members.country_id = country.id AND members.state_id = state.id AND members.city_id = city.id AND members.region_id = region.id) WHERE `country_id` = '2' ORDER BY country ASC, state ASC, city ASC, region ASC";
	
	$result = mysql_query($query, $db);
	$row = mysql_fetch_array($result);