Question

1

Hello,

i've got a SQL query which returns multiple rows, and i have :

$data = array(
    "nom" => $row['nom'] ,
    "prix"   => $row['rapport'],
    "average"   => "$moyenne_ge"
  );

which is perfect, but only if my query returns one row.

i tried that :

$data = array();
$data[$row['nom']]["nom"] = $row['nom'] ;
...
$data[$row['nom']]['average']  = "$moyenne_ge";

in order to have :

$data[brand1][nom] = brand1
$data[brand1][average] = 150$
$data[brand2][nom] = brand2
$data[brand2][average] = 20$
...

but when i do : json_encode($data)

i only have the latest JSON object instead of all JSON object from my request as if my array has only one brand instead of 10.

I guess i did something stupid somewhere. Thanks for your help

flag	asked Apr 18 at 23:04 Tristan 42●6 100% accept rate

Can you show a little more code? I guess you have a loop somewhere, it would help to see it. – deceze Apr 18 at 23:10

Bill Karwin · Answer 1 · 2010-04-18 23:26:34Z

2

I'd guess that your line:

$data = array();

Is initializing the array on each iteration of your loop. You aren't accumulating more than one row of data.

answered Apr 18 at 23:26

Bill Karwin
47.8k●5●39●91

thanks you for your time ;) – Tristan Apr 18 at 23:37

Tatu Ulmanen · Answer 2 · 2010-04-18 23:25:30Z

I guess something like this should work for you:

$resource = mysql_query("YOUR QUERY");
$results = array()

while($result = mysql_fetch_assoc($resource)) {
    $results[$result['brand']] = array(
        'nom' => $result['nom'],
        'prix' => $result['rapport'],
        'average' => $moyenne_ge
    );
)

$results now contains all the rows from the query indexed by brand. Ask in comments if this wasn't what you're looking for.

Paul · Answer 3 · 2010-04-18 23:26:00Z

If I am reading you right, you should just have to do something like this:

$data[] = array(
    "nom" => $row['nom'] ,
    "prix"   => $row['rapport'],
    "average"   => "$moyenne_ge"
);

(notice the [])

This should append each array onto $data instead of overwriting the contents.

PHP array : simple question about multidimensional array

3 Answers

Your Answer

Not the answer you're looking for? Browse other questions tagged arrays php multidimensional-array json or ask your own question.

Hello World!

Related