Sort the fragments as well, otherwise it can look strange

diff --git a/src/LinuxTag/2005/supporter/jobs.wml b/src/LinuxTag/2005/supporter/jobs.wml
index 78c1ca9..c303ae0 100644 (file)
--- a/src/LinuxTag/2005/supporter/jobs.wml
+++ b/src/LinuxTag/2005/supporter/jobs.wml
@@ -58,7 +58,7 @@
   }
 
   $query = "SELECT job.id,title,starttime,endtime FROM job,fragment "
-                  ."WHERE job.id = fragment.job ORDER BY title";
+                  ."WHERE job.id = fragment.job ORDER BY title,starttime";
 
   $sth = pg_exec ($dbh, $query) or die ("Datenbank-Abfrage!");
 

diff --git a/src/LinuxTag/2005/supporter/open.wml b/src/LinuxTag/2005/supporter/open.wml
index 7f79e65..0e1ddd0 100644 (file)
--- a/src/LinuxTag/2005/supporter/open.wml
+++ b/src/LinuxTag/2005/supporter/open.wml
@@ -48,7 +48,7 @@
   pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
 
   $query = "SELECT job.id,title,starttime,endtime,fragment.id as fragment FROM job,fragment "
-                  ."WHERE job.id = fragment.job ORDER BY title";
+                  ."WHERE job.id = fragment.job ORDER BY title,starttime";
 
   $sth = pg_exec ($dbh, $query) or die ("Datenbank-Abfrage!");