Because this is Perl, another way and probably my way of doing it would be to add another field called "image_order" or something that simple denotes whence in the sequence the image comes. This would be the field you would want to rename when you add/delete an image.

Cons: When you delete an image you would have to change every single other images "image_order" field to match the new ordering.

Pros: Adding an image to the end is easy :). It's also possible to reorder images to any format you want, or completely random. This would not be possible with some of the other schemes people have suggested, mostly relying on the relationship of the creation date (autoincrement). So you could (somewhat) easily insert images in to the middle or the end or whatever.

Of course this problem seems to cry out for a linked list, but I can't really think of a good way to store one.

In reply to Re: mysql auto_incremented id by BUU
in thread mysql auto_incremented id by jwlarson3rd

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.