PHP: Display data from Array

Question

I working on a program and coming up with some annoying issue. I am trying to display data from an array. I copied the format from another array I setup and it works perfect. The only difference is I am gathering a lot more data...

Calling the function:

$data1 = display_orders($_SESSION['user_id'], $limit, 'fName', 'lName', 'VendorName',      'DateRequested', 'Shipping', 'VendorNumber', 'VendorFax', 'VendorAddress', 'VendorCity', 'VendorState', 'VendorZip', 'EquipmentConsumable', 'GasType', 'GasLocation', 'UNMTag', 'EquipmentLocation', 'index', 'totalcost', 'Approved', 'Shipped');

The Function itself

<?php
function display_orders($user_id, $limit)
{
    $data = array();
    $user_id = (int)$user_id;
    $limit = (int)$limit;

        $func_num_args = func_num_args();
        $func_get_args = func_get_args();

//  print_r($func_get_args);
                if ($func_num_args > 1)
                        {
                                unset($func_get_args[0]);
                unset($func_get_args[1]);


                                $fields = '`' . implode('`, `', $func_get_args) . '`';

                for($x = 0; $x < $limit; $x++)
                {   

                $data[] = mysql_fetch_assoc(mysql_query("SELECT $fields  FROM  `users` ,  `vendor` WHERE $user_id = users.id AND $user_id = vendor.user_id ORDER BY vendor.DateRequested DESC"));
                }
                return $data;
            }

}

?>

So now i try to echo the data out:

echo $data1['VendorName'];

I get no output.

If I do the following:

print_r ($data1);

I get output!

Array ( [0] => Array ( [fName] => admin [lName] => test [VendorName] => Newegg [DateRequested] => 2013-09-19 [Shipping] => Standard [VendorNumber] => NA [VendorFax] => NA [VendorAddress] => NA [VendorCity] => NA [VendorState] => NA [VendorZip] => 00000 [EquipmentConsumable] => Equipment [GasType] => [GasLocation] => [UNMTag] => 0 [EquipmentLocation] => Computer Lab [index] => 0 [totalcost] => 39.99 [Approved] => 0 [Shipped] => 0 ) )

But if i try to add a field name No data....

Any help and I would be grateful!

Use echo '<pre>', print_r($data1), '</pre>'; for a formatted output of the array. — Amal
– Amal, Commented Sep 19, 2013 at 22:13

Amal · Accepted Answer · 2013-09-19 22:12:13Z

5

As you see, $data1 is Array([0] => Array(...)), so you'll need to call

echo $data1[0]['VendorName'];

This is because you are assigning data as $data[] = mysql_fetch_assoc(...).

edited Sep 19, 2013 at 22:12

Amal

76.8k18 gold badges133 silver badges154 bronze badges

answered Sep 19, 2013 at 22:08

Al_

1,5011 gold badge11 silver badges23 bronze badges

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

Comments

Kenny · Accepted Answer · 2013-09-19 22:10:03Z

3

echo $data1[0]['VendorName'];

I suggest when using print_r you first echo <PRE> as it will help you to see the true structure of the array easier. In this case, the location of VendorName is one layer deeper than you are echoing.

edited Sep 19, 2013 at 22:10

answered Sep 19, 2013 at 22:09

Kenny

1,5539 silver badges16 bronze badges

Comments

Amal · Accepted Answer · 2013-09-19 22:11:40Z

0

You forgot the index [0]:

echo $data1[0]['VendorName'];

edited Sep 19, 2013 at 22:11

Amal

76.8k18 gold badges133 silver badges154 bronze badges

answered Sep 19, 2013 at 22:10

Tele Guida

1

Collectives™ on Stack Overflow

PHP: Display data from Array

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related