"; echo ""; echo "DEALERSHIPS:"; echo ""; while($row=mysql_fetch_array($getDeal)){ $MyCompID = $row['comp_id']; $dealID = $row['dealer_id']; //echo $dealID; $compName = mysql_result(mysql_query("SELECT `comp_code` FROM `vts_company` WHERE `comp_id`='$MyCompID'"),0); $dealName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$dealID'"),0); $dealCode = mysql_result(mysql_query("SELECT `deal_code` FROM `vts_dealerships` WHERE `deal_id`='$dealID'"),0); if($dealName !=''){ $count = $count + 1; } //echo $dealID; if($count < 1){ echo " Sorry, you do not have access to any of the dealerships under ".$compName.".

Please contact your system Administrator of Assistance."; echo ""; }else{ echo " ".$dealName.""; echo ""; } } echo ""; ?>