Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if(isset($_POST['submit']))
- {
- $sql="SELECT vendor.id AS venid
- , vendor.name AS VNAME
- , vendor.category
- , vendor.website
- , vendor.email
- , vendor.phone
- , vendor.vat
- , vendor.pan
- , items.name AS iname
- , location.name AS locname
- , items.item_id
- FROM vendor
- INNER JOIN vendor_location ON vendor.id = vendor_location.vendor_id
- INNER JOIN vendor_products ON vendor.id=vendor_products.vendor_id
- INNER JOIN location ON vendor_location.location = location.loc_id
- INNER JOIN items ON vendor_products.item_id=items.item_id
- ORDER BY vendor.id";
- }
- $sql1 = mysql_query($sql) or die(mysql_error());
- }
- ?>
- <div class="w-box w-box-blue">
- <div class="w-box-header">
- <h4>Vendor</h4>
- </div>
- <div class="w-box-content">
- <table id="dt_hScroll" class="table table-striped">
- <thead><tr>
- <th>Vendor ID</th>
- <th>Vendor</th>
- <th>Category</th>
- <th>Website</th>
- <th>Email</th>
- <th>Phone</th>
- <th>VAT</th>
- <th>PAN</th>
- <th>Products</th>
- <th>Locations</th>
- </tr>
- </thead>
- <tbody>
- <?php
- $current = ''; // STORE THE SUPPLIER SID
- while($row = mysql_fetch_array($sql1)) {
- if ($row['venid'] != $current) {
- echo "<tr>
- <td><a href='edit_vendor_details.php?id=$row[venid]'>{$row['venid']}</a></td>
- <td>{$row['VNAME']}</td>
- <td>{$row['category']}</td>
- <td>{$row['website']}</td>
- <td>{$row['email']}</td>
- <td>{$row['phone']}</td>
- <td>{$row['vat']}</td>
- <td>{$row['pan']}</td>
- ";
- $current = $row['venid']; // RESET STORED SID
- }
- else {
- echo "<tr><td colspan='8'> </td>";
- }
- echo "<td>{$row['iname']}</td>";
- echo "<td>{$row['locname']}</td>";
- echo "</tr>";
- }
- echo('</tbody></table>');
- ?>
- </tbody></table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement