Anton: 1 oder 2 Queries nötig?

Beitrag lesen

So sieht es fast schon mal ungefähr so aus, wie es sein soll.

while ($row =& $res->fetchRow(DB_FETCHMODE_ASSOC)) {
        $data[] = $row;
    }

$richtig[] = $data[0];
    $last_id = $richtig[0]['id'];

for ($i = 0; $i < $obergrenze; $i++) {
        if ($last_id != $data[$i]['id']) { // different person
            $last_id = $data[$i]['id'];
            $richtig[] = $data[$i];
        } else { // same person
         $richtig[count($richtig)-1]['email'] = $data[count($richtig)]['email'].", ".$data[count($richtig)]['email'];
        }
    }

print "<pre>";
print_r($richtig);
print "</pre>";

ergibt:

Array
(
    [0] => Array
        (
            [id] => 1
            [pic] => ...
            [email] => email1@..., email2@...
            [function] => Vertriebsinnendienst Nord & Ost
            [fax] => ...
            [phone] => ...
            [name] => Nachname1, Vorname1
            [folder] => ...
        )

[1] => Array
        (
            [id] => 24
            [pic] => ...
            [email] => email1@...
            [function] => Export Frankreich, Belgien, Niederlande
            [fax] => ...
            [phone] => ...
            [name] => Nachname2, Vorname2
            [folder] => ...
        )

Es soll aber so aussehen:

Array
(
    [0] => Array
        (
            [id] => 1
            [pic] => ...
            [email] =>
                [0] => Array
                    (
                       [0] => email1@...,
                       [1] => email2@...,
                       ...
                    )
            [function] => Vertriebsinnendienst Nord & Ost
            [fax] => ...
            [phone] => ...
            [name] => Nachname1, Vorname1
            [folder] => ...
        )