arbitrary list ordering

• bry

  i'm working on a photo gallery managed by PHP/mySQL.

  what's the most elegant way to set an arbitrary ordering of the photos in a gallery?

  i was originally thinking assigning a priority/rank level to the DB row corresponding each picture (1 to 5 or something like that) but i doubt that fully does the trick.

  i also considered actually enumerating the photos, i.e., giving them each a number corresponding to what order they appear... but that seems to involve significant overhead in making certain that the order numbers are unique to their gallery, something that i'd rather not do.

  is there an easier way?

  bry

  Flag