How i can make a while in a array?

knaller1 said:

Hey,

so i have a problem i want to execute a script like that.

PHP:

$updateArticle = array(   'configuratorSet' => array(        'groups' => array(
            array(                'name' => 'Farbe',                'options' => array(

// HERE IS THE PROBLEM

                if ($resultatfarben = $db->query('SELECT * FROM cache_article WHERE artikelnummer = '.$herstellnummer.' GROUP BY farben')) {                  while($datenfarben = $resultatfarben->fetch_object() ){                array('name' => ''.$datenfarben->farbe.''),
                  }                  }
// PROBLEM END


                )            ),...

I market the Error Code in the Text. How i can do the same result but so its work?
But i need the result of this like

PHP:

array('name' => "Green"),
array('name' => "Blue"),
array('name' => "Yellow"),

How i can do that?
I hope you understand... my english is very bad.


Thank You

Click to expand...

$data_array[]="";
if ($resultatfarben = $db->query('SELECT * FROM cache_article WHERE artikelnummer = '.$herstellnummer.' GROUP BY farben')) {
while($datenfarben = $resultatfarben->fetch_object() ){
$data_set = array('name' => $datenfarben['name']);
array_push($data_array,$data_set);
}
}

Click to expand...