title: How to make drop down menu from web2py database
body: <p>I'm trying to populate a drop down navigation bar from a web2py database of product names. The table is defined in db.py like so:</p>
  
  <pre><code>db.define_table('product',
  Field('prodid', unique=True),
  Field('name'),
  Field('stock', 'integer'))
  </code></pre>
  
  <p>I've done a bit of research and found heaps of ways to do it with PHP from an SQL database but I haven't been able to find anything about retrieving from a local database in web2py. </p>
  
  <p>Any help would be appreciated. </p>