php mysql query result array and foreach loop

Question

Any one have idea how to do the following:

I have the following mysql query :

client 1026 has two clients under him: 1056 (on the left ) & 1497 ( on the right ) and each of client 1056 and client 1497 has two other clients under them, and so on

now i want to make a loop to collect all the clients under the client 1026

i have this mysql query

$sql_query="select id from rev_r_clients WHERE parent_client_id='1026'";
$res = mysql_query($sql_query);
$ids=array();
while($row = mysql_fetch_object($res)){
    $ids[]=$row->id;
}
$ids=array_filter($ids);
foreach($ids as $id){
    echo $id;
    echo '<br>';
    $sql_query="select id from rev_r_clients WHERE parent_client_id='$id'";
    $res = mysql_query($sql_query);
    $ids=array();
    while($row = mysql_fetch_object($res)){
        $ids[]=$row->id;
    }
    $ids=array_filter($ids);
    foreach($ids as $id){
        echo $id;
    }
}

it return

1056

106410801497

15051521

now how can i make this query get array result ( like 1056,1497 ) and then use foreach loop to get the result and the result of the result of the result etc.. until there is no more result?

You can use mysql , mysqli , PDO all i want is to accomplish the request

If you've got an arbitrarily deep tree, then the only way I can think of to do what you want is through recursion - you'll need to get a client's sub-clients; then check if any of those have their own sub-clients, and so on. — andrewsi
– andrewsi, Commented Dec 19, 2013 at 17:24
@user3117183 - the standard way would be to create a function that takes a client's ID as the parameter; that queries for sub-clients of that client. If there are any, it calls itself, passing in each sub-client's ID in turn. — andrewsi
– andrewsi, Commented Dec 19, 2013 at 17:39

Rahi · Accepted Answer · 2013-12-19 18:00:40Z

3

$ids=array();
while($row = mysql_fetch_object($res)){
ids[]=$row->id;
 }
$ids=array_filter($ids);
/*To remove empty array*/
foreach($ids as $id){
echo $id;
 }

edited Dec 19, 2013 at 18:00

answered Dec 19, 2013 at 17:40

Rahi

3241 silver badge11 bronze badges

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

3 Comments

user3117183 Over a year ago

ok now how can we do the foreach loop ?to look for the clients under each client id?

Rahi Over a year ago

foreach($ids as $id){}

Rahi Over a year ago

look define a array variable first .Then store each element in that array. Then loop through foreach ok

Collectives™ on Stack Overflow

php mysql query result array and foreach loop

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related