.-.-.-.-.-

<?php include 'header.php';?>
<h3>My product purchase </h3>
 <table border="1" style="border-collapse:collapse;">
    <thead>
        <tr>
            <th>Sno.</th>
            <th>
                P. Code
            </th>
            <th>
                P. Name
            </th>
            <th>
               Franchise ID
            </th>
            <th>
                Franchise name
            </th>
            <th>
                P. Cost
            </th>
            <th>B.V.</th>
            <th>BV. amount</th>
            <th>
                Qty.
            </th>
            <th>Purchase date</th>
            
        </tr>
    </thead>
    <tbody>
        <?php
        $uid = $_SESSION['userid'];
        $count = 1;
        $query = "select pr.pcode as pcode, pr.pname as pname, pr.pv as pv, pr.pcost as pcost, f.fid as fid, f.name as name,
        ps.quantity as quantity, ps.pv_amount as pv_amount, ps.date as date
        from product as pr, franchise as f, product_sale as ps where pr.pid = ps.pid and f.fid = ps.fid  and ps.uid = $uid";
        $result = mysqli_query($connection, $query);
        while($row = mysqli_fetch_object($result)){
            echo "<tr><td>$count</td><td>$row->pcode</td> <td>$row->pname</td> <td>$row->fid</td> <td>$row->name</td><td>$row->pcost</td> 
                   <td>$row->pv</td><td>$row->pv_amount</td><td>$row->quantity</td> <td>$row->date</td> <tr> ";
            $count++;
        }
        ?>
    </tbody>
</table>

<?php include "footer.php";?>

/home2/wtmwscom/public_html/member/product_u.php