I am trying to add records from my database to a table as a list of links that takes the user to a more details page about vendors they can view. But only the first record is being put in the table where as the rest are appearing as a jumbled up mess outside the table at the bottom of it.
Can anyone see what I've done wrong with my table echos?
<?php
session_start();
$link = mysqli_connect("localhost", "root", "root") or die(mysqli_error($db));
mysqli_select_db($link, "keepers")
or die(mysqli_error($link));
// Check connection
if($link === false)
{
die("ERROR: Could not connect. " . mysqli_connect_error());
}
?>
<html>
<head>
<title>Beekeeper</title>
<meta name="author" content="Nigel Kennington">
<meta name="description" content="Find local honey near you">
<meta name="keywords" content="honey, bees, bee, local">
<link href="bees.css" type="text/css" rel="stylesheet">
</head>
<body>
<div id="linkbar">
<table height="140px" ID="Table1">
<tr>
<td valign="bottom"><a href="index.php">Home</a> |</td>
<td valign="bottom"><a href="about.html">About</a> |</td>
<td valign="bottom"><a href="contact.html">Contact</a></td>
</tr>
</table>
</div>
<div id="bulk">
<table width="100%" border="0" cellpadding="0" cellspacing="0" ID="Table1">
<tr id="spacer">
<td class="leftnav" align="right" valign="top" nowrap width="120px">
<h5>Find Honey from:</h5>
<p><a href="HaL.php">Highlands and Islands</a></p>
<p><a href="NES.php">North Eastern Scotland</a></p>
<p><a href="ES.php">Eastern Scotland</a></p>
<p><a href="SWS.php">South Western Scotland</a>
<h5>List your produce:</h5>
<p><a href="keeperlogin.php">Keepers Page</a></p>
</td>
<td>
<?php
$sql = "SELECT * FROM keepers WHERE area = 'HaI'";
$result = mysqli_query($link, $sql);
echo "<table width=100% border='1'>
<tr>
<th><p class='success'>Shop Name</p></th>
<th><p class='success'>Shop Email</p></th>
<th><p class='success'>Town</p></th>
<th><p class='success'>Phone Number</p></th>
<th><p class='success'>Mobile Number</p></th>
</tr>";
while($row = mysqli_fetch_assoc($result))
{
$id = $row['ID'];
echo "$id";
echo "<tr>";
echo "<td> <a href='viewdetails.php?id=$id'>" . $row['shop_name'] . "</a> </td>";
echo "<td> <a href='viewdetails.php?id=$id'>" . $row['shop_email'] . "</a> </td>";
echo "<td> <a href='viewdetails.php?id=$id'>" . $row['town'] . "</a> </td>";
echo "<td> <a href='viewdetails.php?id=$id'>" . $row['phone_number'] . "</a> </td>";
echo "<td> <a href='viewdetails.php?id=$id'>" . $row['mobile_number'] . "</a> </td>";
echo "</tr>";
echo "</table>";
}
?>
</td>
</tr>
</table>
</div>
<div id="footer">
© 2008 beekeeper.com | <A href="privacy.html">Privacy Policy</A> |
<A href="terms.html">Terms of Use</A>
</div>
</body>