[m_abdelfattah]

I've Mysql Table with these data :

id parent_id name
1 0 Sub 1
2 1 sub 2
3 2 sub 3

I want to make function that I can pass `id` to it , and it return an array with all parents,
for example :
function get_parent_ids(3) {
..
..
return (2, 1, 0)
}

so, how can I write this code ??

and what if I want to get the childs ?
for example :
function get_parent_ids(0) {
..
..
return (1, 2, 3)
}


Thanks for your time !!

[m_abdelfattah]

I found a solution for 1st one :

PHP Code:

function get_parent_districts($district_id) {

        $parent_ids = array();

        $exclude = array();

        while($district_id !== 0) {

            $query = $this->db->query("SELECT `parent_id` FROM `districts` WHERE `district_id`=" . $this->db->escape($district_id) . "") or die(mysql_error());

            $row = $query->row_array();

            $parent_ids[] = $row['parent_id'];

            $district_id = $row['parent_id'];

            if($district_id === "0") {

                break;

            }

        }

        return $parent_ids;

    }