";
$conn = odbc_connect("MS", "", "");
$sql1 = "SELECT idnr,datum FROM [order] WHERE kund LIKE '" .$_SESSION['kid']. "' ORDER BY idnr DESC";
$query_id1 = odbc_exec($conn, $sql1);
$tot_pris = 0;
while (odbc_fetch_row($query_id1)){
$idnr = odbc_result($query_id1, "idnr");
$datum = odbc_result($query_id1, "datum");
print "
";
print "| Ordernummer: $idnr | Datum: $datum |
";
print "| Antal | Artist | Titel | Pris |
";
$sql2 = "SELECT skiva, antal FROM [orderrad] WHERE [order] LIKE '$idnr'";
$query_id2 = odbc_exec($conn, $sql2);
while (odbc_fetch_row($query_id2)){
$skiva = odbc_result($query_id2, "skiva");
$antal = odbc_result($query_id2, "antal");
$sql3 = "SELECT Artist, Titel, Pris FROM skiva WHERE Idnr LIKE '$skiva'";
$query_id3 = odbc_exec($conn, $sql3);
while (odbc_fetch_row($query_id3)){
$artist = odbc_result($query_id3, "Artist");
$titel = odbc_result($query_id3, "Titel");
$pris = odbc_result($query_id3, "Pris");
$tot_pris += $pris;
print "| $antal st. | ";
print "$artist | ";
print "$titel | ";
print "$pris |
";
}
}
print "| Summa: | $tot_pris |
";
print "
";
}
odbc_close($conn);
print "