From: short <>
Date: Sun, 7 Mar 2004 19:02:11 +0000 (+0000)
Subject: Report years in reverse order on the main page.
X-Git-Url: https://git.jankratochvil.net/?p=www.energie.vellum.cz.git;a=commitdiff_plain;h=6f5e714e06b9262bd8c3e9143b26474b330d881e

Report years in reverse order on the main page.
---

diff --git a/index.php b/index.php
index 001d4a1..1c91815 100644
--- 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);