changeset 356:965d43fffdd2

Order slides in rotation list by slide order_num.
author Matti Hamalainen <ccr@tnsp.org>
date Tue, 03 Dec 2013 08:55:50 +0200
parents 4ced04d29858
children 7e906c827e68
files showajax.php
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/showajax.php	Tue Dec 03 08:55:28 2013 +0200
+++ b/showajax.php	Tue Dec 03 08:55:50 2013 +0200
@@ -116,7 +116,7 @@
       // Get list of slides from active rotation list
       $list = stGetDisplayVar("rotateList");
       $sql = stPrepareSQL(
-        "SELECT * FROM displayListSlides WHERE list_id=%d ORDER BY id",
+        "SELECT * FROM displayListSlides WHERE list_id=%d ORDER BY order_num",
         $list);
 
       if (($slideList = stExecSQL($sql)) !== false)