One thing to consider is whether you want this to be a controlled vocabulary. i.e. Are there a limited number of choices that you want people to have? If this is the case, then they can be hard coded into a pull-down form.

If, on the other hand, you want to generate the current list of comapny names reflecting recent additions, then you would need to do something like this: 

select distinct ID_no, Company_Name from Companies
order by CompanyName

[download]
(I put in an ID_no assuming that this is a relational database and you are using surrogate keys. You may need them further along in the query form)

Then you would take the array returned by the SELECT and use it to populate the drop-down list.

-----
"Computeri non cogitant, ergo non sunt"

In reply to Re: Drop Down Selection From Database by cadfael
in thread Drop Down Selection From Database by koacamper

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.