Dynamic Form Pulldown

[beesfan_london]

Hi, i'm pretty new to PHP so please go easy on me. I'm building a form and need to have the options in a pulldown menu pulled from a mysql database, i understand the basics of sql and have used forms before, i just need to see an example to get me on my way.

 

Does anyone on here know of a good tutorial?

 

Thanks,

Andrew

[trq]

<?php

  $sql = "SELECT item FROM menu";
  if ($result = mysql_query($sql) && mysql_num_rows($result)) {
    echo "<select name=\"menu\">";
    while ($row = mysql_fetch_assoc($result)) {
      echo "  <option name=\"{$row['item']}\">{$row['item']}</option>";
    }
    echo "</select>";
  }

?>