Changeset 454

Timestamp:

Mar 1, 2009, 2:39:01 PM (16 years ago)

Author:

amun

Message:

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

File:

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

branches/beta/inc/html.php

@@ -222 +222 @@
   $limit = 5;
      
-        $sql = mysql_query("SELECT SQL_CALC_FOUND_ROWS * FROM articles ".$where." ORDER BY date DESC, id DESC LIMIT $limit OFFSET " . intval($_GET["offset"]);
-                $sql_pocet = mysql_query(mysql_num_rows("SELECT date FROM articles ".$where.);
-        if ($sql_pocet > 0)
+        $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 !!
@@ -274 +274 @@
                   
 
-$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";
@@ -283 +283 @@
 
 $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"]) {
     echo "<a href='$_SERVER[PHP_SELF]" . ($_GET["strana"] != 1 ? "?strana=" . ($_GET["strana"] - 1) : "") . "'>zpět</a>\n";