Display a drop-down menu whose content from database

[aas1611]

Hi,

I have this drop-down menu, a list of authors. The name of the authors are in a database, I want to display it automatically, instead of writing the authors' names one by one.

The code I have written here does not work (which I thought should work), and I dont' know what else I can do:

echo "<tr><td>Author</td><td><select name=author size=1>";
$result = mysql_query("SELECT Name FROM Authors");
while ($rw = mysql_fetch($result)) {
   echo "<option>".$rw['Name'];
}
echo "</select></td></tr>";

With this code, the drop-down menu come up empty. It IS connected to the database, in case you were wondering

Can anybody appoint where I screw up? Thanks!

Andre

 

[jpadie]

echo "<tr><td>Author</td><td><select name=\"author\" size=\"1\">";
$result = mysql_query("SELECT `Name` FROM Authors") or die(mysql_error());
while ($rw = mysql_fetch_assoc($result)) {
   echo "<option value=\"{$rw['Name']}\">{$rw['Name']}</option>";
}
echo "</select></td></tr>";