data from the database to select drop down

[gary4u]

  Hi,

  I am trying to insert a data from the database to select drop down list in a table where this comes in the    4th column. But it does not work. There is already data from the database to other columns and it is          working , but this is not working for the 4th column in the drop down list.

 How do you add in a table 4 th column -

This is not working -

   echo   "<td> <select> <?php 
            $sql = "SELECT name FROM categories"; 
            $result=mysql_query($sql);
            while ($row = mysql_fetch_array($result));
            <option>". $row[name] ." </option>
             }
            ?> </select></td>";
            echo "<td><a href=productedit1.php?ID=".$row[id].">Approve</a></td>";           
            echo "<td><a href=deletecategory.php?ID=".$row[id]."
            onClick=\"return confirm('Are you sure you want to delete?')\">Delete</a></td>";
               }                              
            echo "</tr>";
            echo "</table>";                                  

           Please let me know.
                Thanks

                Gary