.-.-.-.-.-

<?php
$title= "Royalty Report";
include 'header.php';
include_once('lib/ps_pagination.php');

if(isset($_GET['login_id'])){ $uid = mysqli_fetch_object(mysqli_query($connection, "SELECT uid FROM user WHERE login_id = '".$_GET['login_id']."'"))->uid; }

$param .= isset($_GET['login_id']) && $_GET['login_id']!='' ? "&amp;login_id=".$_GET['login_id'] : '';
$param .= isset($_GET['from_date']) && $_GET['from_date']!='' ? "&amp;from_date=".$_GET['from_date'] : '';
$param .= isset($_GET['to_date']) && $_GET['to_date']!='' ? "&amp;to_date=".$_GET['to_date'] : '';
$query = "SELECT recid, uid, amount, tds, service_tax, service, net_amount, datetime, status FROM `withdraw` WHERE uid != 0";
$query .= isset($_GET['login_id']) && $_GET['login_id']!='' ? " AND uid='".$uid."'" : '';
$query .= isset($_GET['from_date']) && $_GET['from_date']!='' && isset($_GET['to_date']) && $_GET['to_date']!='' ? " AND (datetime BETWEEN '".$_GET['from_date']."' AND '".$_GET['to_date']."')" : '';
$query .= " ORDER BY `datetime` DESC";
?>
   <h1>Club membership Report</h1>
    <?php echo getMessage();?>
    <section>
        <table style="width: 100%;" class="table table-striped table-hover">
          <thead>
            <tr>
              <th>S. No.</th>
              <th>Amount</th>
              <th>Club</th>
              <th>Rate</th>
              <th>Income (%)</th>
            </tr>
          </thead>
          <tbody>
              <tr>
                  <td>1.</td>
                  <td>500000</td>
                  <td>Silver Club</td>
                  <td>1 %</td>
                  <td>-</td>
              </tr>
              <tr>
                  <td>2.</td>
                  <td>1500000</td>
                  <td>Gold Club</td>
                  <td>1 %</td>
                  <td>-</td>
              </tr>
              <tr>
                  <td>3.</td>
                  <td>5000000</td>
                  <td>Platinum Club</td>
                  <td>1 %</td>
                  <td>-</td>
              </tr>
              <tr>
                  <td>4.</td>
                  <td>20000000</td>
                  <td>Ruby Club</td>
                  <td>1 %</td>
                  <td>-</td>
              </tr>
              <tr>
                  <td>5.</td>
                  <td>500000000</td>
                  <td>Diamond Club</td>
                  <td>1 %</td>
                  <td>-</td>
              </tr>
          </tbody>
        </table>
      </section>
<?php include 'footer.php';?>

/home2/wtmwscom/public_ftp/../www/admin/report_royalty.php