以 PHP 官網範例 來改

<?php
$serverName = "serverName\instanceName";
$connectionInfo = array( "Database"=>"dbName", "UID"=>"username", "PWD"=>"password");
$conn = sqlsrv_connect( $serverName, $connectionInfo );
if( $conn === false ) {
    die( print_r( sqlsrv_errors(), true));
}

$sql = "SELECT * FROM table where id = 'AA11**'";
$stmt = sqlsrv_query( $conn, $sql );
if( $stmt === false) {
    die( print_r( sqlsrv_errors(), true) );
}

$rowcnt = 0;
while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {
   $rowcnt = $rowcnt + 1;   
   if ($rowcnt==1) { //第一筆,特別處理
      //1.用 $row['Id'],$row['Date'],$row['Qa1'],$row['Qa2']顯示表頭
      //2.顯示表身標題列(Num, Id, Date... )
      //3.用 $row['Qa3'], $row['Qa4'], $row['Qa5'] 顯示表身資料列
   } else {   //第二筆(含)以後
      //只需用 $row['Qa3'], $row['Qa4'], $row['Qa5'] 顯示表身資料列
   }
   echo $row['LastName'].", ".$row['FirstName']."<br />";
}

sqlsrv_free_stmt( $stmt);
?>

難得看到一個比較用心的發問, 就給你詳細一點的程式

首先按照你原本的表格設計方式, 可以這樣寫(注意我把表格欄位改名了)：

query.php

<?php

$pdo = require_once "sample_db.php";

$records = $pdo->query("SELECT * FROM record;");
$prevId = $prevDate = $prevShopId = null;
$rowNum = 0;
foreach($records as $data) {
    if ($prevId !== $data["Id"]
        || $prevDate !== $data["Date"]
        || $prevShopId !== $data["ShopId"]
    ) {
        $rowNum = 0;
        $prevId = $data["Id"];
        $prevDate = $data["Date"];
        $prevShopId = $data["ShopId"];
    }

    if (0 === $rowNum++) {
        print "======================================\n";
        print "Num: {$data["Num"]}, Id: {$data["Id"]}, ";
        print "Date: {$data["Date"]}, ShopId: {$data["ShopId"]}, ";
        print "{$data["ShopName"]}\n";
    }
    print "--------------------------------------\n";
    print "{$data["ProdId"]}, {$data["ProdName"]}, {$data["Qty"]}\n";
}

在終端機執行, 輸出長這樣：

======================================
Num: 1, Id: AA1100, Date: 2016-10-28, ShopId: 123123, 麥當勞
--------------------------------------
FF33A, 漢堡, 1
--------------------------------------
HB77H, 薯條, 1
--------------------------------------
RGJ32, 蕃茄醬, 2
--------------------------------------
BBDDA, 糖醋醬, 3
======================================
Num: 5, Id: AA1100, Date: 2016-10-29, ShopId: 111111, MOS
--------------------------------------
RFAXS, 可樂, 5
--------------------------------------
HJKLA, 雪碧, 4

這是 sample_db.php, 只是建樣本資料, 可略過不看

<?php

$db_filename = "db.sqlite";
$db_exists = file_exists($db_filename);

$pdo = new PDO("sqlite:$db_filename", null, null);

if (!$db_exists) {
    $pdo->exec("CREATE TABLE record(Num INTEGER PRIMARY KEY, Id, Date, ShopId, ShopName, ProdId, ProdName, Qty);");
    $datas = array(
        array(
            'Id' => "AA1100",
            'Date' => "2016-10-28",
            'ShopId' => "123123",
            'ShopName' => "麥當勞",
            'ProdId' => "FF33A",
            'ProdName' => "漢堡",
            'Qty' => 1
        ),
        array(
            'Id' => "AA1100",
            'Date' => "2016-10-28",
            'ShopId' => "123123",
            'ShopName' => "麥當勞",
            'ProdId' => "HB77H",
            'ProdName' => "薯條",
            'Qty' => 1
        ),
        array(
            'Id' => "AA1100",
            'Date' => "2016-10-28",
            'ShopId' => "123123",
            'ShopName' => "麥當勞",
            'ProdId' => "RGJ32",
            'ProdName' => "蕃茄醬",
            'Qty' => 2
        ),
        array(
            'Id' => "AA1100",
            'Date' => "2016-10-28",
            'ShopId' => "123123",
            'ShopName' => "麥當勞",
            'ProdId' => "BBDDA",
            'ProdName' => "糖醋醬",
            'Qty' => 3
        ),
        array(
            'Id' => "AA1100",
            'Date' => "2016-10-29",
            'ShopId' => "111111",
            'ShopName' => "MOS",
            'ProdId' => "RFAXS",
            'ProdName' => "可樂",
            'Qty' => 5
        ),
        array(
            'Id' => "AA1100",
            'Date' => "2016-10-29",
            'ShopId' => "111111",
            'ShopName' => "MOS",
            'ProdId' => "HJKLA",
            'ProdName' => "雪碧",
            'Qty' => 4
        ),
    );

    foreach ($datas as $data) {
        $sql = <<<END_SQL
            INSERT INTO record(Id, Date, ShopId, ShopName, ProdId, ProdName, Qty)
            VALUES(
                '{$data["Id"]}',
                '{$data["Date"]}',
                '{$data["ShopId"]}',
                '{$data["ShopName"]}',
                '{$data["ProdId"]}',
                '{$data["ProdName"]}',
                '{$data["Qty"]}'
            );
END_SQL;

        $pdo->exec($sql);
    }
}

return $pdo;

但是你這資料表的設計, 如果要打分數的話, 只能給你 50 分不及格。因為你完全沒有做正規化。
這邊不跟你解釋什麼叫正規化, 網路上隨便搜尋都有資料, 自己去查。

我直接給你一個對購買清單正規化的範例, 注意這個範例沒有把正規化做完, 只做了一小步而已：

sample_db2.php

<?php

$db_filename = "db2.sqlite";
$db_exists = file_exists($db_filename);

$pdo = new PDO("sqlite:$db_filename", null, null);

if (!$db_exists) {
    $pdo->exec("CREATE TABLE record(Num INTEGER PRIMARY KEY, Id, Date, ShopId, ShopName);");
    $pdo->exec("CREATE TABLE items(fk_Num, ProdId, ProdName, Qty)");

    $pdo->exec("INSERT INTO record(Id, Date, ShopId, ShopName) VALUES ('AA1100', '2016-10-28', '123123', '麥當勞')");
    $fk_Num = $pdo->lastInsertId();
    $pdo->exec("INSERT INTO items VALUES ($fk_Num, 'FF33A', '漢堡', 1)");
    $pdo->exec("INSERT INTO items VALUES ($fk_Num, 'HB77H', '薯條', 1)");
    $pdo->exec("INSERT INTO items VALUES ($fk_Num, 'RGJ32', '蕃茄醬', 2)");
    $pdo->exec("INSERT INTO items VALUES ($fk_Num, 'BBDDA', '糖醋醬', 3)");

    $pdo->exec("INSERT INTO record(Id, Date, ShopId, ShopName) VALUES ('AA1100', '2016-10-29', '111111', 'MOS')");
    $fk_Num = $pdo->lastInsertId();
    $pdo->exec("INSERT INTO items VALUES ($fk_Num, 'RFAXS', '可樂', 5)");
    $pdo->exec("INSERT INTO items VALUES ($fk_Num, 'HJKLA', '雪碧', 4)");
}

return $pdo;

這樣子做, 你的資料庫就會有兩個表格, 一個紀錄消費的時間及店家資料, 另一個紀錄消費內容。兩個表格利用 Num 與 fk_Num 做關聯查詢, 最後出來的可以跟你原本表格的內容一模一樣。

例如利用 join 來處理, 這邊除了 sql 語法變了, 其餘程式都沒有變動：

query2.php

<?php

$pdo = require_once "sample_db2.php";

$records = $pdo->query("SELECT record.*, items.* FROM record LEFT JOIN items ON record.Num = items.fk_Num;");
$prevId = $prevDate = $prevShopId = null;
$rowNum = 0;
foreach($records as $data) {
    if ($prevId !== $data["Id"]
        || $prevDate !== $data["Date"]
        || $prevShopId !== $data["ShopId"]
    ) {
        $rowNum = 0;
        $prevId = $data["Id"];
        $prevDate = $data["Date"];
        $prevShopId = $data["ShopId"];
    }

    if (0 === $rowNum++) {
        print "======================================\n";
        print "Num: {$data["Num"]}, Id: {$data["Id"]}, Date: {$data["Date"]}, ";
        print "ShopId: {$data["ShopId"]}, {$data["ShopName"]}\n";
    }
    print "--------------------------------------\n";
    print "{$data["ProdId"]}, {$data["ProdName"]}, {$data["Qty"]}\n";
}

最後再給你一點提示, 你的商店名稱跟商品名稱都需要正規化。而正規化請 "至少" 做到 3NF 才及格。

另外以上的程式需要在 php 5.4 以上, 且有安裝 pdo 與 sqlite 的環境才能運作。