Recursive SQL consult PHP

Question

I'm trying to do a recursive sql query, searching for all the children of a father and the children of that children, and so on.. The problem with the code below is that it only retrieves the first children tree.

I need to save all the emails of the entire tree in an array

$hermanos = array();
function obtener($id){
    $res = mysql_query("SELECT email,id FROM usuarios WHERE padre = '$id'", Conectar::con());
    while($row = mysql_fetch_assoc($res)){ 
        if ($row['email'] != 'waiting') {
            $hermanos[] = $row['email'];
            obtener($row['id']);
        }
    }
    return $hermanos;
}
$a = obtener($invitado);
print_r($a);

score 1 · Answer 1 · edited May 23 '17 at 10:32

1

From the vague description I think you want another solution. This is called Hierchial data retireval according to db language. I think these kind of recursive queries should be done on db end with procedures/views You can check these links for heirchial data

edited May 23 '17 at 10:32

Community

1
1

answered Dec 29 '13 at 23:09

Gun2sh

870
12
22

Recursive SQL consult PHP

1 Answers1