OneHundred - 13515005 - Husnulzaki Wibisono Haryadi

K02 - Anggota:

1. Husnulzaki Wibisono Haryadi 13515005
2. Muhammad Umar Fariz Tumbuan 13515050
3. Akmal Fadlurohman 13515074

order/select_driver.php

@@ -31,7 +31,7 @@
 				function ShowPrefDrv($prefdrv, $con)
 				{
 					if (!(is_null($prefdrv))) {
-						$pdQuery = mysqli_query($con, "SELECT * FROM driver RIGHT OUTER JOIN (SELECT * FROM user WHERE name='" . $prefdrv . "') AS usert ON user_id = driver_id") or die(mysqli_error($con));
+						$pdQuery = mysqli_query($con, "SELECT * FROM driver NATURAL JOIN user WHERE name='$prefdrv'") or die(mysqli_error($con));
 
 						while ($row = mysqli_fetch_assoc($pdQuery)) {
 							$driver_id = $row['driver_id'];