/me sees only posts from jptxs, scratches head...

Umm, glad we could help? =)

BTW, in the future you probably don't want to do what you did in Table 1. Putting a list in a field with commas is pure, unadulterated evil. The database gods will forsake you for such blasphemy.

Many-to-many lookups are best accomplished with cross-tables: 

Table1:
 Act  | ...
 __________
 Act1 | ...
 Act2 | ...
 Act3 | ...
 Act4 | ...

Table2:
 id | name
 _________
 1  | foo
 2  | bar
 3  | this
 6  | that
 8  | hey

XTable12:
 Act  | id
 __________
 Act1 | 1
 Act1 | 2
 Act2 | 3
 Act2 | 2
 Act3 | 6
 Act4 | 2
 Act4 | 8

Its going to suck if some person comes along behind ya and wants to stick 5 things in that list and there are only 8 chars allowed. =) I should know, I had to fix this for someone once (And we paid them hundreds of thousands of dollars for it... grr...)

--
$you = new YOU;
honk() if $you->love(perl)

In reply to RE: reversing a hash -- printing it by extremely
in thread reversing a hash -- printing it by jptxs

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.