What about a second table with a key that references the first table. I don't really have enougth information to be of exact assistance but if I had a user and a list associated with that user of arbitrary length I would put a second table in with a primary key unique to that table and a key in both tables that matched the user somehow either the UserID or another ID so that the first table referenced the first and all that needed to be done is push the results from a fetchrow_array into an array with a loop. Then delete from the second table all records having that key when you need to get rid of them. If you want to do that after a certain time MySQL has a time function or store the epcoh time from perl as a field and then use that as part of the SQL query. Good Luck

In reply to Re: arrays in database by Angel
in thread arrays in database by dev2000

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.