"; echo ""; echo ""; while($row=mysql_fetch_array($result)){ $salesID=$row['sales_id']; $custID=$row['cust_id']; $isFleet=$row['is_fleet']; $SelCompID=$row['comp_id']; $SelDealID=$row['deal_id']; //$SalesPerson = mysql_result(mysql_query("SELECT `employee_id` FROM `vts_users` WHERE `employee_id`='$salesID'"),0); $selCompName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$SelCompID'"),0); $selDealName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$SelDealID'"),0); ?>".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

REC. ID	Type	Customer Name	Sales Agent	Company	Dealership	Date Created	Status
"; if($row['is_fleet']==='No'){ echo "non-fleet"; }else{ echo "fleet"; } echo"	".$row['prospect_name']."	".$salesID."	".$row['prospect_name']."	".$selDealName."	".$row['date_added']."	".$row['status']."

"; echo"