Subalbums phpMyAdmin

Hey! Is there a way to sort subalbums manually through phpMyAdmin?

Comments

  • I sort my subalbums trough phpMyadmin..
    I place a number in the field 'Place' to ad an order to the albums and subalbums.
    hen on my album page I use thuis to show the album thumbs in an sorted way.

    <?php function printSortedAlbumThumbImage($alt, $thumb, $class=NULL, $id=NULL) {
    echo "<img src=\"" . htmlspecialchars($thumb) . "\" style=\"z-index:5;\" id=\"$alt\" />";
    } ?>
    <?php while (next_album()):

    $title = getAlbumTitle();
    $albums[$title]["date"] = getAlbumDate();
    $albums[$title]["location"] = getAlbumPlace();
    $albums[$title]["title"] = htmlspecialchars($title, ENT_QUOTES);
    $albums[$title]["url"] = GetAlbumLinkURL();
    $albums[$title]["desc"] = getAlbumDesc();
    $albums[$title]["thumb"] = getAlbumThumb();
    endwhile;
    if ($albums) {
    array_multisort($albums, SORT_ASC);
    foreach ($albums as $album) { ?>" title="" ><?php printSortedAlbumThumbImage($album["title"], $album["thumb"]);?>
    <?php } ?>
    <?php } ?>
  • Thanks!
Sign In or Register to comment.