- Branch/Dealership -"; $sql = "SELECT * FROM `vts_dealerships` WHERE `deal_status`=1 AND `comp_id`= '$activeCompany' ORDER BY `deal_name` ASC"; $qSql = mysqli_query($conn,$sql); while($row = mysqli_fetch_array($qSql)){ echo "".$row['deal_name'].""; } } $conn->close(); ?>