I'd really appreciate any advice.

Here's some high-level advice: Life gets easier when you can break a problem in independent sub-problems. Building a pop-up menu from a database is a great example of a problem that divides into parts that can be developed and tested independently. The only trick in combining the two is deciding on the data structure that communicates the results of the first sub-problem (getting the data out of database) with the second sub-problem (turning it into a pop-up menu).

Dividing the problem increases the likelihood of getting help. Instead of dumping a large problem on the table, you pose a smaller, more focused one. In this case, "How do I fetch a set of rows from MySQL and turn them into (some data structure)?"

Or, if your question is "what datastructure is best if I want to create a pop-up menu?", ask that. Notice how MySQL drops away entirely.

Asking focused questions improves your chances of getting focused answers.

In reply to Re: popup_menu from database by dws
in thread popup_menu from database by powerhouse

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.