";
echo "
| CODE |
COMPANY |
DEALERSHIP |
ADDRESS |
CITY |
STATUS |
";
while($row=mysql_fetch_array($result)){
echo "
";
echo "| ".$row['deal_code']." | ";
echo "";
$compCode = mysql_result(mysql_query("SELECT `comp_code` FROM `vts_company` WHERE `comp_id`='".$row['comp_id']."'"),0);
echo $compCode;
echo " | ";
echo "".$row['deal_name']." | ";
echo "".$row['deal_address']." | ";
echo "".$row['deal_city']." | ";
echo "";
if($row['deal_status']==1){echo 'Active';}else{echo 'InActive';}
echo" | ";
echo "
";
}
echo "";
?>