".$count."";
echo "| ".$brd." | ";
echo "".$row['m_name']." | ";
echo "".$row['m_desc']." | ";
echo "";
if(isset($_GET['deal']) && ($_GET['deal']!='')){ //DEALER COUNT ONLY
$mySelDeal=$_GET['deal'];
$getTotalAvail = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE `sold` = 0 AND `returned` = 0 AND `reserved` = 0 AND `incoming_unit` = 0 AND `brand_code`='$model' AND `company`='$comName' AND `dealer`='$mySelDeal'"),0);
}else{
$getTotalAvail = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE `sold` = 0 AND `returned` = 0 AND `reserved` = 0 AND `incoming_unit` = 0 AND `brand_code`='$model' AND `company`='$comName'"),0);
}
echo $getTotalAvail;
echo " | ";
echo "";
if(isset($_GET['deal']) && ($_GET['deal']!='')){ //DEALER COUNT ONLY
$getTotalRes = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE `sold` = 0 AND `reserved`= 1 AND `returned` = 0 AND `brand_code`='$model' AND `company`='$comName' AND `dealer`='$mySelDeal'"),0);
}else{
$getTotalRes = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE `sold` = 0 AND `reserved`= 1 AND `returned` = 0 AND `brand_code`='$model' AND `company`='$comName'"),0);
}
echo $getTotalRes;
echo " | ";
echo "";
if(isset($_GET['deal']) && ($_GET['deal']!='')){ //DEALER COUNT ONLY
$getTotalINC = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE `sold` = 0 AND `reserved`= 0 AND `returned` = 0 AND `incoming_unit` = 1 AND `brand_code`='$model' AND `company`='$comName' AND `dealer`='$mySelDeal'"),0);
}else{
$getTotalINC = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE `sold` = 0 AND `reserved`= 0 AND `returned` = 0 AND `incoming_unit` = 1 AND `brand_code`='$model' AND `company`='$comName'"),0);
}
echo $getTotalINC;
echo " | ";
echo "";
if(isset($_GET['deal']) && ($_GET['deal']!='')){ //DEALER COUNT ONLY
$getTotal = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE `sold` = 0 AND `returned` = 0 AND `brand_code`='$model' AND `company`='$comName' AND `dealer`='$mySelDeal'"),0);
}else{
$getTotal = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE `sold` = 0 AND `returned` = 0 AND `brand_code`='$model' AND `company`='$comName'"),0);
}
echo $getTotal;
echo " | ";
echo "
";
}
}
echo "";
//OF VALIDATION
?>
