format("Y/m/d");
if(isset($_POST['searchText'])){
$searchText = mysql_real_escape_string($_POST['searchText']);
$ActiveCompanyCode = mysql_real_escape_string($_POST['ActiveCompanyCode']);
$bBrand = mysql_real_escape_string($_POST['bBrand']);
$getBrand = mysql_query("SELECT * FROM `db_vehicle_inventory` WHERE `brand`= '$bBrand' AND `company` ='$ActiveCompanyCode' AND `reserved`= 1 AND `sold` = 0 AND `cs_number` LIKE '%$searchText%' || `brand` = '$bBrand' AND `company` ='$ActiveCompanyCode' AND `reserved`= 1 AND `sold` = 0 AND `brand_code` LIKE '%$searchText%' ORDER BY brand DESC");
//VALIDATE ACCESS
echo "SEARCH RESULT - ".$searchText."
";
echo "";
echo "";
echo "| UNIT ID | ";
echo "DATE | ";
echo "CS NUMBER | ";
echo "AGENT CODE | ";
echo "VARIANT | ";
echo "MAKE | ";
echo "V. MODEL | ";
echo "COLOR | ";
echo "";
while($row=mysql_fetch_array($getBrand)){
?>".$row['id']."";
echo "| ".$row['saved_date']." | ";
echo "".$row['cs_number']." | ";
echo "".$row['tagged']." | ";
echo "".$row['description']." | ";
echo "".$row['year_model']." | ";
echo "".$row['brand_code']." | ";
echo "".$row['color']." | ";
echo "
";
}
echo "
";
//OF VALIDATION
}
?>