Create string from multi-dimensional array values

Question

I have a code like this:

$user = JFactory::getUser();
$user_id= $user->get('id');

$db = JFactory::getDbo();
$db->setQuery("SELECT virtuemart_user_id, order_number, order_total, created_on FROM `kunkp_virtuemart_orders` WHERE `virtuemart_user_id`='$user_id' ");

$row = $db->loadRowList();

print_r($row);`

The output of the result is like this:


Array
(
    [0] => Array
        (
            [0] => 42
            [1] => 10e803
            [2] => 122.05487
            [3] => 2013-06-10 20:34:39
        )

    [1] => Array
    (
        [0] => 42
        [1] => 901e04
        [2] => 349.78500
        [3] => 2013-06-11 07:28:19
    )

)

Here, 10e803 & 901e04 is order number. I want to store all the order number in `$order_number` string & want to print the value of `$order_number` . How I can do that. I tried with foreach like this:

`foreach($row as $d){

    $order_number .= $d[1];
}
echo $order_number;

But it's not working. Anyone can help me please.

you have to initialize $order_number first. Place $order_number = ""; before the foreach. — geryjuhasz
– geryjuhasz, Commented Jun 16, 2013 at 7:51

Kylie · Accepted Answer · 2013-06-16 07:53:44Z

1

Replace this...

 `foreach($row as $d){

with this....

$order_number = "";   
 foreach($row as $val){
    $order_number.= ",".$val[1];
 }
echo $order_number;

edited Jun 16, 2013 at 7:53

answered Jun 16, 2013 at 7:48

Kylie

11.8k11 gold badges51 silver badges81 bronze badges

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

1 Comment

Kylie Over a year ago

Are you sure thats your structure when outputting $row....can you echo "<pre>" before you print_r, so we can see it more visually than on one line

Collectives™ on Stack Overflow

Create string from multi-dimensional array values

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related