X-Git-Url: https://jasonwoof.com/gitweb/?p=wfpl-cms.git;a=blobdiff_plain;f=admin_pages.php;h=768b47d2b8ab6c4ff8f6b44bd9a394a330a3089d;hp=382ff5c78e777290c9733baa68405ff3d711dee8;hb=a2eea0ebfb5a15b80fc0d76be90f4ab453539be0;hpb=e7424acd48ed670f1b8bd8d7c1ff69b37ce6334b diff --git a/admin_pages.php b/admin_pages.php index 382ff5c..768b47d 100644 --- 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;