mysql search database duplicated

[chrisleon]

I have figured out how to display my search criteria, but now the results are all duplicated, here is the code, I cannot see the duplication, so can someone please help again. I appreciate any bit of advice you can give.

<?php
if ($submit){
$db = mysql_connect("localhost", "root");
mysql_select_db ("menagerie") or die ("Sorry, database Problems. Please try again.");
$result = mysql_query ("SELECT * FROM VENDOR WHERE vend_num LIKE '%$SearchBox%'") or die ("Sorry no results. Please try again.");
$numrs = mysql_num_rows($result);
print "<b>Here are your results: $numrs records.</b>";
print "<table>\n";
while ($line = mysql_fetch_array($result)) {
print "<tr>\n";
while(list($col_name, $col_value) = each($line)) {
print "<td>$col_value</td>\n";
}
print "\t</tr>\n";
}

print "</table>\n";
mysql_close($db);
}

[hand]

Instead of
while ($line = mysql_fetch_array($result)) {
try it with
while ($line = mysql_fetch_assoc($result)) {
or
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {

http://www.php.net/manual/en/function.mysql-fetch-array.php