I'm gonna go for 'in the database'. Putting it in the script just seems 'wrong'. It's better to have all that sort of data in one place, from an overall point of view. Supposing you come back to the code a year later, or someone else attempts to understand it, and starts out by just looking at the database, you'll have a level_id in there that makes no sense.

After all, if its *never* going to change, you could just put the level name in the profiles table and have done with it. (Yes, thats a repition of data, but not much..) So, if its even 'slightly' likely its going to take place, its much better to have it in the database anyway, since in theory you can add to that without changing code.

Even if this is just a little script written for your use only, try to think a little more globally. Someday someone might ask for a script that does something like this, and you'll give it to them without thinking about it, so make it as easy to comprehend as possible, including for yourself several years later.

C.

In reply to Re: hash or tables... by castaway
in thread hash or tables... by kiat

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.