Changeset 455

Timestamp:

Mar 1, 2009, 2:46:35 PM (16 years ago)

Author:

amun

Message:

...

File:

• branches/beta/inc/html.php (modified) (3 diffs)

branches/beta/inc/html.php

@@ -221 +221 @@
   mysql_select_db($db_webu);
   $limit = 5;
-     
-        $sql = mysql_query("SELECT * FROM articles $where ORDER BY date DESC, id DESC LIMIT $limit OFFSET " . intval($_GET["offset"]);
-                $pocet = mysql_query(mysql_num_rows("SELECT date FROM articles $where ");
-        if ($pocet > 0)
-        {
-        // TODO !!
-                
-  while ($row = mysql_fetch_array($sql))
-          {
-            switch ($row["category"]) 
+     mysql_query("SET NAMES 'utf8'");
+$result = mysql_query("SELECT SQL_CALC_FOUND_ROWS * FROM articles $where ORDER BY date DESC LIMIT $limit OFFSET " . intval($_GET["offset"]));
+$pocet = mysql_query(mysql_num_rows("SELECT date FROM `articles` $where ");
+if ($pocet > 0)
+        {
+while($row = mysql_fetch_array($result)){
+ switch ($row["category"]) 
             {
               case 1:
@@ -271 +268 @@
             <br />
             ";
-          }
-                  
+}
+$pocet = mysql_result(mysql_query(" SELECT FOUND_ROWS()"), 0);
+if ($_GET["offset"]) {
+    echo "<a href='$_SERVER[PHP_SELF]" . ($_GET["offset"] != $limit ? "?offset=" . ($_GET["offset"] - $limit) : "") . "'>zpět</a>\n";
+}
+if ($pocet > $_GET["offset"] + $limit) {
+    echo "<a href='$_SERVER[PHP_SELF]?offset=" . ($_GET["offset"] + $limit) . "'>vpřed</a>\n";
+}
 
 
-if ($_GET["offset"]) {
-    echo "<a href='$_SERVER[PHP_SELF]" . ($_GET["offset"] != $limit ? "?offset=" . ($_GET["offset"] - $limit) : "") . "'>zpět</a>\n";
-}
-if ($pocet > $_GET["offset"] + $limit) {
-    echo "<a href='$_SERVER[PHP_SELF]?offset=" . ($_GET["offset"] + $limit) . "'>vpřed</a>\n";
-}
-
-$result = mysql_query("SELECT SQL_CALC_FOUND_ROWS * FROM articles ".$where." ORDER BY date DESC, id DESC LIMIT $limit OFFSET " . ($limit * $_GET["strana"]));
-
+$result = mysql_query("SELECT SQL_CALC_FOUND_ROWS * FROM articles $where ORDER BY date DESC $limit OFFSET " . ($limit * $_GET["strana"]));
+$pocet = mysql_result(mysql_query(" SELECT FOUND_ROWS()"), 0);
 if ($_GET["strana"]) {
     echo "<a href='$_SERVER[PHP_SELF]" . ($_GET["strana"] != 1 ? "?strana=" . ($_GET["strana"] - 1) : "") . "'>zpět</a>\n";
@@ -290 +286 @@
     echo "<a href='$_SERVER[PHP_SELF]?strana=" . ($_GET["strana"] + 1) . "'>vpřed</a>\n";
 }
+  
         
         }