".$row['comp_id']."";
echo "| ".strtoupper($row['comp_code'])." | ";
echo "".strtoupper($row['comp_name']);
echo "";
$getavDealer = mysql_query("SELECT * FROM `vts_dealerships` WHERE `comp_id`='$assetCompID'");
echo " ";
echo "";
while($vRow=mysql_fetch_array($getavDealer)){
?>".$vRow['deal_id']."";
echo "| ".$vRow['deal_code']." | ";
echo "".$vRow['deal_name']." | ";
echo "";
$getDealID = $vRow['deal_id'];
$getDealGMID = mysql_result(mysql_query("SELECT `gm_id` FROM `vts_dealerships` WHERE `deal_id`='$getDealID'"),0);
$dealGMLname = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$getDealGMID'"),0);
$dealGMFname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$getDealGMID'"),0);
echo strtoupper($dealGMLname). ", ". strtoupper($dealGMFname);
echo " | ";
echo " ";
}
echo "";
echo " ";
echo " | ";
echo "
";
}
?>