<?php 
$query="SELECT pid,name,active FROM ".$prefix."package ORDER BY name ASC";
$packageType=mysqli_query($linkid,$query);

$query="SELECT id,memberID,fname,mname,lname,floorno,address,billingcontact,amount,billingdate,package,IP,MAC,openingdate FROM ".$prefix."member_personal WHERE package='DADICATED BANDWIDH'";
$memberType1=mysqli_query($linkid,$query);

$query="SELECT id,memberID,fname,mname,lname,floorno,address,billingcontact,amount,billingdate,package,IP,MAC,openingdate FROM ".$prefix."member_personal WHERE package='PACKAGE-5 USERS'";
$memberType2=mysqli_query($linkid,$query);

$query="SELECT id,memberID,fname,mname,lname,floorno,address,billingcontact,amount,billingdate,package,IP,MAC,openingdate FROM ".$prefix."member_personal WHERE package='PACKAGE-4 USERS'";
$memberType3=mysqli_query($linkid,$query);

$query="SELECT id,memberID,fname,mname,lname,floorno,address,billingcontact,amount,billingdate,package,IP,MAC,openingdate FROM ".$prefix."member_personal WHERE package='PACKAGE-3 USERS'";
$memberType4=mysqli_query($linkid,$query);

$query="SELECT id,memberID,fname,mname,lname,floorno,address,billingcontact,amount,billingdate,package,IP,MAC,openingdate FROM ".$prefix."member_personal WHERE package='PACKAGE-2 USERS'";
$memberType5=mysqli_query($linkid,$query);

$query="SELECT id,memberID,fname,mname,lname,floorno,address,billingcontact,amount,billingdate,package,IP,MAC,openingdate FROM ".$prefix."member_personal WHERE package='PACKAGE-1 USERS'";
$memberType6=mysqli_query($linkid,$query);
?>

<div id="contentwrapper">
  <div class="main_content">
    <nav>
      <div id="jCrumbs" class="breadCrumb module">
        <ul>
          <li> <a href="#"><i class="icon-home"></i></a> </li>
          <li> <a href="#">Manage</a> </li>
          <li> <a href="index.php?tab=member">All Users</a> </li>
        </ul>
      </div>
    </nav>
	<h4 class="heading" align="left">DADICATED BANDWIDH</h4>
    <div class="row-fluid">
      <div class="span12">
        <table class="table table-striped table-bordered dTableR">
          <thead>
            <tr>
              <th>ID</th>
              <th>Name</th>
              <th>Address</th>
			  <th>Floor</th>
              <th>Cell</th>
			  <th>IP</th>
			  <th>MAC</th>
              <th>O.Date</th>
			  <th>Package</th>
			  <th>Amount</th>
			</tr>
          </thead>
          <tbody>
            <?php 
			  if($memberType1)
				{
				while($mydata = mysqli_fetch_assoc($memberType1))
				{
			  ?>
				<tr class="bar<?php echo $mydata['id']?>">
				  <td><?php echo $mydata['memberID']?></td>
				  <td><?php echo $mydata['fname']." ".$mydata['mname']." ".$mydata['lname']?></td>
				  <td><?php echo $mydata['address']?></td>
				  <td><?php echo $mydata['floorno']?></td>
				  <td><?php echo $mydata['billingcontact']?></td>
				  <td><?php echo $mydata['IP']?></td>
				  <td><?php echo $mydata['MAC']?></td>
				  <td><?php echo $mydata['openingdate']?></td>
				  <td><?php echo $mydata['package']?></td>
				  <td><?php echo $mydata['amount']?></td>
				  
				</tr>
            <?php 
				 }
				 } 
			?>
          </tbody>
        </table>
      </div>
    </div>
	<h4 class="heading" align="left">PACKAGE-5 USERS</h4>
    <div class="row-fluid">
      <div class="span12">
        <table class="table table-striped table-bordered dTableR">
          <thead>
            <tr>
              <th>ID</th>
              <th>Name</th>
              <th>Address</th>
			  <th>Floor</th>
              <th>Cell</th>
			  <th>IP</th>
			  <th>MAC</th>
              <th>O.Date</th>
			  <th>Package</th>
			  <th>Amount</th>
			</tr>
          </thead>
          <tbody>
            <?php 
			  if($memberType2)
				{
				while($mydata = mysqli_fetch_assoc($memberType2))
				{
			  ?>
				<tr class="bar<?php echo $mydata['id']?>">
				  <td><?php echo $mydata['memberID']?></td>
				  <td><?php echo $mydata['fname']." ".$mydata['mname']." ".$mydata['lname']?></td>
				  <td><?php echo $mydata['address']?></td>
				  <td><?php echo $mydata['floorno']?></td>
				  <td><?php echo $mydata['billingcontact']?></td>
				  <td><?php echo $mydata['IP']?></td>
				  <td><?php echo $mydata['MAC']?></td>
				  <td><?php echo $mydata['openingdate']?></td>
				  <td><?php echo $mydata['package']?></td>
				  <td><?php echo $mydata['amount']?></td>
				  
				</tr>
            <?php 
				 }
				 } 
			?>
          </tbody>
        </table>
      </div>
    </div>
	<h4 class="heading" align="left">PACKAGE-4 USERS</h4>
    <div class="row-fluid">
      <div class="span12">
        <table class="table table-striped table-bordered dTableR">
          <thead>
            <tr>
              <th>ID</th>
              <th>Name</th>
              <th>Address</th>
			  <th>Floor</th>
              <th>Cell</th>
			  <th>IP</th>
			  <th>MAC</th>
              <th>O.Date</th>
			  <th>Package</th>
			  <th>Amount</th>
			</tr>
          </thead>
          <tbody>
            <?php 
			  if($memberType3)
				{
				while($mydata = mysqli_fetch_assoc($memberType3))
				{
			  ?>
				<tr class="bar<?php echo $mydata['id']?>">
				  <td><?php echo $mydata['memberID']?></td>
				  <td><?php echo $mydata['fname']." ".$mydata['mname']." ".$mydata['lname']?></td>
				  <td><?php echo $mydata['address']?></td>
				  <td><?php echo $mydata['floorno']?></td>
				  <td><?php echo $mydata['billingcontact']?></td>
				  <td><?php echo $mydata['IP']?></td>
				  <td><?php echo $mydata['MAC']?></td>
				  <td><?php echo $mydata['openingdate']?></td>
				  <td><?php echo $mydata['package']?></td>
				  <td><?php echo $mydata['amount']?></td>
				  
				</tr>
            <?php 
				 }
				 } 
			?>
          </tbody>
        </table>
      </div>
    </div>
	<h4 class="heading" align="left">PACKAGE-3 USERS</h4>
    <div class="row-fluid">
      <div class="span12">
        <table class="table table-striped table-bordered dTableR">
          <thead>
            <tr>
              <th>ID</th>
              <th>Name</th>
              <th>Address</th>
			  <th>Floor</th>
              <th>Cell</th>
			  <th>IP</th>
			  <th>MAC</th>
              <th>O.Date</th>
			  <th>Package</th>
			  <th>Amount</th>
			</tr>
          </thead>
          <tbody>
            <?php 
			  if($memberType4)
				{
				while($mydata = mysqli_fetch_assoc($memberType4))
				{
			  ?>
				<tr class="bar<?php echo $mydata['id']?>">
				  <td><?php echo $mydata['memberID']?></td>
				  <td><?php echo $mydata['fname']." ".$mydata['mname']." ".$mydata['lname']?></td>
				  <td><?php echo $mydata['address']?></td>
				  <td><?php echo $mydata['floorno']?></td>
				  <td><?php echo $mydata['billingcontact']?></td>
				  <td><?php echo $mydata['IP']?></td>
				  <td><?php echo $mydata['MAC']?></td>
				  <td><?php echo $mydata['openingdate']?></td>
				  <td><?php echo $mydata['package']?></td>
				  <td><?php echo $mydata['amount']?></td>
				  
				</tr>
            <?php 
				 }
				 } 
			?>
          </tbody>
        </table>
      </div>
    </div>
	<h4 class="heading" align="left">PACKAGE-2 USERS</h4>
    <div class="row-fluid">
      <div class="span12">
        <table class="table table-striped table-bordered dTableR">
          <thead>
            <tr>
              <th>ID</th>
              <th>Name</th>
              <th>Address</th>
			  <th>Floor</th>
              <th>Cell</th>
			  <th>IP</th>
			  <th>MAC</th>
              <th>O.Date</th>
			  <th>Package</th>
			  <th>Amount</th>
			</tr>
          </thead>
          <tbody>
            <?php 
			  if($memberType5)
				{
				while($mydata = mysqli_fetch_assoc($memberType5))
				{
			  ?>
				<tr class="bar<?php echo $mydata['id']?>">
				  <td><?php echo $mydata['memberID']?></td>
				  <td><?php echo $mydata['fname']." ".$mydata['mname']." ".$mydata['lname']?></td>
				  <td><?php echo $mydata['address']?></td>
				  <td><?php echo $mydata['floorno']?></td>
				  <td><?php echo $mydata['billingcontact']?></td>
				  <td><?php echo $mydata['IP']?></td>
				  <td><?php echo $mydata['MAC']?></td>
				  <td><?php echo $mydata['openingdate']?></td>
				  <td><?php echo $mydata['package']?></td>
				  <td><?php echo $mydata['amount']?></td>
				  
				</tr>
            <?php 
				 }
				 } 
			?>
          </tbody>
        </table>
      </div>
    </div>
	<h4 class="heading" align="left">PACKAGE-1 USERS</h4>
    <div class="row-fluid">
      <div class="span12">
        <table class="table table-striped table-bordered dTableR">
          <thead>
            <tr>
              <th>ID</th>
              <th>Name</th>
              <th>Address</th>
			  <th>Floor</th>
              <th>Cell</th>
			  <th>IP</th>
			  <th>MAC</th>
              <th>O.Date</th>
			  <th>Package</th>
			  <th>Amount</th>
			</tr>
          </thead>
          <tbody>
            <?php 
			  if($memberType6)
				{
				while($mydata = mysqli_fetch_assoc($memberType6))
				{
			  ?>
				<tr class="bar<?php echo $mydata['id']?>">
				  <td><?php echo $mydata['memberID']?></td>
				  <td><?php echo $mydata['fname']." ".$mydata['mname']." ".$mydata['lname']?></td>
				  <td><?php echo $mydata['address']?></td>
				  <td><?php echo $mydata['floorno']?></td>
				  <td><?php echo $mydata['billingcontact']?></td>
				  <td><?php echo $mydata['IP']?></td>
				  <td><?php echo $mydata['MAC']?></td>
				  <td><?php echo $mydata['openingdate']?></td>
				  <td><?php echo $mydata['package']?></td>
				  <td><?php echo $mydata['amount']?></td>
				  
				</tr>
            <?php 
				 }
				 } 
			?>
          </tbody>
        </table>
      </div>
    </div>
  </div>
</div>
