dogbreeds_php

<?php
include_once "../includes/db.php";

$sql = "SELECT * FROM dogbreeds ORDER BY dogbreed";
$result = mysqli_query($_SESSION['dblink'],$sql);


?>
<p><a href="dogbreed_form.php">Add Dog Breed</a></p>

<table class='datatable'>
    <caption>Dog Breeds</caption>
    <tr>
        <th>Dog Breed</th>
        <th>Description</th>
        <th>Country</th>
        <th>Price</th>
        <th>Discount Rate</th>
        <th>Manage</th>
    </tr>
    <?php
    while ($record = mysqli_fetch_assoc($result)) {
        ?>
        <tr>
            <td><?php print $record['dogbreed'];?></td>
            <td><?php print $record['description'];?></td>
            <td><?php print $record['country_code'];?></td>
            <td><?php print $record['price'];?></td>
            <td><?php print $record['discount_rate'];?></td>
            <td><a href="edit_dogbreed.php?dogbreed=<?php echo $record['dogbreed'];?>">Edit</a>&nbsp;&nbsp;<a href="delete_dogbreed.php?dogbreed=<?php echo $record['dogbreed'];?>">Del</a></td>
        </tr>
        <?php
    }
    ?>
</table>