<!-- Collection of code snippets by Arne Vajhøj -->
<!-- posted to eksperten.dk, usenet and other places (2002-now) -->
<?php

class Item {
    public $dt;
    public $vals;
    public function __construct($dt) {
        $this->dt = $dt;
        $this->vals = array();
    }
}

function load() {
    $res = array();
    $con = new mysqli('localhost', 'root', '', 'Test');
    $stmt = $con->prepare("SELECT dt, val FROM iddtval ORDER BY dt");
    $stmt->execute();
    $rs = $stmt->get_result();
    $lastdt = 'notexisting';
    while($row = $rs->fetch_array(MYSQLI_ASSOC)) {
        $dt = $row['dt'];
        $val = $row['val'];
        if($dt != $lastdt) {
            $res[] = new Item($dt);
            $lastdt = $dt;
        }
        $res[count($res) - 1]->vals[] = $val;
    }
    $stmt->close();
    $con->close();
    return $res;
}

function display($data) {
    foreach($data as $item) {
        $dt = $item->dt;
        $vals = implode(',', $item->vals);
        echo "$dt $vals\r\n";
    }
}

$data = load();
display($data);
?>