Changeset 452 for branches/beta/inc

Timestamp:

Mar 1, 2009, 2:25:32 PM (16 years ago)

Author:

amun

Message:

Stránkování novinek... (pokus číslo 2)

File:

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

branches/beta/inc/html.php

@@ -219 +219 @@
         }
         $this -> db -> select_db($db_webu);
-        $sql = $this -> db -> query("SELECT * FROM `articles`".$where."ORDER BY `date` DESC;");
+        $sql = $this -> db -> query("SELECT SQL_CALC_FOUND_ROWS * FROM articles ".$where." ORDER BY date DESC, id DESC LIMIT $limit OFFSET " . intval($_GET["offset"]);
         if ($sql -> num_rows > 0)
         {
@@ -280 +280 @@
 }
 
-$result = mysql_query("SELECT SQL_CALC_FOUND_ROWS * FROM tabulka ORDER BY datum DESC, id DESC LIMIT $limit OFFSET " . ($limit * $_GET["strana"]));
+$result = mysql_query("SELECT SQL_CALC_FOUND_ROWS * FROM articles ".$where." ORDER BY date DESC, id DESC LIMIT $limit OFFSET " . ($limit * $_GET["strana"]));
 $pocet = mysql_result(mysql_query(" SELECT FOUND_ROWS()"), 0);
 if ($_GET["strana"]) {