SCHEMA CHANGE, clean up /admin_images

[wfpl-cms.git] / admin_pages.php

diff --git a/admin_pages.php b/admin_pages.php
index 382ff5c..768b47d 100644 (file)
--- a/admin_pages.php
+++ b/admin_pages.php
@@ -75,7 +75,7 @@ function admin_pages_main_delete($id) {
 # get all images from admin_images (for cms)
 function admin_pages_get_images() {
        $out = [];
-       $rows = db_get_assocs('cms_images', 'image,name,caption', 'order by name, caption, image');
+       $rows = db_get_assocs('cms_images', 'image,name,caption', "order by coalesce(nullif(name, ''), caption), created_at");
        if ($rows) {
                $id = -1;
                foreach($rows as &$row) { $id += 1;