Report years in reverse order on the main page.
authorshort <>
Sun, 7 Mar 2004 19:02:11 +0000 (19:02 +0000)
committershort <>
Sun, 7 Mar 2004 19:02:11 +0000 (19:02 +0000)
index.php

index 001d4a1..1c91815 100644 (file)
--- a/index.php
+++ b/index.php
@@ -22,7 +22,7 @@
        // yet, it is better to at least provide the last year.
        $year=db_item("select max(year) from $tb_obsah");
 
-       $result=db_query("select distinct year from $tb_obsah order by year");
+       $result=db_query("select distinct year from $tb_obsah order by year desc");
        while (($row=mysql_fetch_array($result)))
                print("\t\t<li><a href=\"title.php?year=".$row["year"]."\">Roèník ".$row["year"]."</a></li>\n");
        mysql_free_result($result);