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);

What's your question?

symcbean
– symcbean

2013-12-29 23:28:34 +00:00
Commented Dec 29, 2013 at 23:28 — symcbean
– symcbean, Commented Dec 29, 2013 at 23:28

Community · Accepted Answer · 2017-05-23 10:32:20Z

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, 2017 at 10:32

CommunityBot

11 silver badge

answered Dec 29, 2013 at 23:09

Momin

86812 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Recursive SQL consult PHP

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related