Convert PHP Array into usable variable

Question

Trying to get my array values into a usable variable. I would like to output these values into something readable to that I can use them in a SELECT call for my next statement. The final result I would like to be able to do something like echo $numresults and should look like this 9,8,6 My code as follows will out put the following using print_r as seen below.

Array ( [0] => 9 ) Array ( [0] => 8 ) Array ( [0] => 6 )

I feel like I am close but not sure how to get this array into a usable variable.

while ($rowa = mysql_fetch_assoc($resulta)) {
    if ($rowa['Count'] > 0) {
        $cids[]= $rowa['id'];
        display_id($rowa['id'], $levela + 1);
    } elseif ($rowa['Count']==0) {
        $cids[]= $rowa['id'];
    }

}
print_r($cids);

Both are really close however when using the rtrim, substr($string, 0, -1); mb_substr($string, 0, -1); function to remove the last , in the output it will remove all the commas and bring the output from 9,8,6, to 986 — Mark Wollerman
– Mark Wollerman, Commented Nov 11, 2017 at 17:57

Klevis Cipi · Accepted Answer · 2017-11-11 16:41:02Z

1

$cids = "";

while ($rowa = mysql_fetch_assoc($resulta)) {
    if ($rowa['Count'] > 0)  {
        $cids = $cids . $rowa['id'] . ",";
        display_id($rowa['id'], $levela + 1);
    } elseif ($rowa['Count']==0) {
        $cids = $rowa['id'];
    }
}

print_r($cids);

edited Nov 11, 2017 at 16:41

Klevis Cipi

377 bronze badges

answered Nov 11, 2017 at 16:38

Jesse Schokker

8967 silver badges19 bronze badges

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

2 Comments

Mark Wollerman Over a year ago

Both are really close however when using the rtrim, substr($string, 0, -1); mb_substr($string, 0, -1); function to remove the last , in the output it will remove all the commas and bring the output from 9,8,6, to 986

Mark Wollerman Over a year ago

Fixed it simply changed to $cids .",". $rowa['id']; from $cids . $rowa['id'] . ","; works perfect now

Collectives™ on Stack Overflow

Convert PHP Array into usable variable

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related