Add new employee Staff ID Full Name Phone number D.O.B House number Street City Postcode Job Role '; require_once "../Config/config.php"; $SQL = "SELECT staff.*, users.Job_Role, users.Security_Level FROM staff LEFT JOIN users ON users.Staff_ID = staff.Staff_ID;"; $stmt = mysqli_query($link, $SQL); while ($row = mysqli_fetch_array($stmt)) { $useraccount = ''; $linkerS = "window.location='DetailView.php?ID=" . $row[0] . "';"; if (empty($row[10])) { $useraccount = 'N/A'; } else { $useraccount = $row[10]; } $Table = $Table . ' ' . $row[0] . ' ' . $row[1] . ' ' . $row[2] . ' ' . $row[4] . ' ' . $row[5] . ' ' . $row[6] . ' ' . $row[7] . ' ' . $row[8] . ' ' . $row[9] . ' ' . $useraccount . ' '; } $Table = $Table . ""; ?> Dashboard

Staff: