Order ID Customer Name Employee name Cost Discount VAT Delivery Status '; require_once "../Config/config.php"; $SQL = "SELECT orders.Order_ID, customers.Forename, customers.Surname, staff.Forename, staff.Surname, orders.Cost, orders.Discount, orders.VAT, orders.Delivery_Status FROM orders LEFT JOIN customers ON orders.Customer_ID = customers.Customer_ID LEFT JOIN staff ON orders.User_ID = staff.Staff_ID;"; $stmt = mysqli_query($link, $SQL); while ($row = mysqli_fetch_array($stmt)) { $DelStat = ""; if ($row[8] == 1) { $DelStat = "Delivered"; } else if ($row[8] == 0) { $DelStat = "On Its Way"; } $linkerS = "window.location='DetailView.php?ID=" . $row[0] . "';"; $Table = $Table . ' ' . $row[0] . ' ' . $row[1] . ' ' . $row[2] . ' ' . $row[3] . ' ' . $row[4] . ' ' . $row[5] . ' ' . $row[6] . ' ' . $row[7] . ' ' . $DelStat . ' '; } $Table = $Table . ""; ?> Dashboard

Order Details: