format("Y/m/d");
if(isset($_POST['Display'])){
$brandName = mysql_real_escape_string($_POST['brandName']);
$UserCompanyName = mysql_real_escape_string($_POST['UserCompanyName']);
$UserCompanyID = mysql_real_escape_string($_POST['UserCompanyID']);
$MyUserID = mysql_real_escape_string($_POST['MyUserID']);
}
echo "";
echo "";
echo "";
?>
Scanning. Please wait....
LIST OF RESERVED VEHICLES -
";
echo "";
echo "| UNIT ID | ";
echo "DATE | ";
echo "SALES PERSON | ";
echo "CS NUMBER | ";
echo "BRAND | ";
echo "VARIANT | ";
echo "NOTES | ";
echo "";
while($row=mysql_fetch_array($getBrand)){
$fName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='".$row['sc_id']."'"),0);
$lName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='".$row['sc_id']."'"),0);
$vID = $row['unit_id'];
$company = mysql_result(mysql_query("SELECT `company` FROM `db_vehicle_inventory` WHERE `id`='$vID'"),0);
$cs = mysql_result(mysql_query("SELECT `cs_number` FROM `db_vehicle_inventory` WHERE `id`='$vID'"),0);
$unitCompID = mysql_result(mysql_query("SELECT `comp_id` FROM `vts_company` WHERE `comp_code`='$company'"),0);
if($unitCompID == $UserCompanyID){
?>
".$row['req_id']."";
echo "| ".$row['saved_date']." | ";
echo "".$lName.", ".$fName." | ";
echo "".$cs." | ";
echo "".$row['brand_name']." | ";
echo "".$row['variant_dest']." | ";
echo "".$row['notes']." | ";
echo "
";
}
}
echo "";
//OF VALIDATION
?>