Changeset 453

Timestamp:

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

Author:

amun

Message:

Stránkování novinek... (pokus č.3)

File:

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

branches/beta/inc/html.php

@@ -218 +218 @@
           $where = "WHERE `category` = '".$kategorie."'";
         }
-        $this -> db -> select_db($db_webu);
-        $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)
+ mysql_connect($db_server, $db_user, $db_pass);
+  mysql_select_db($db_webu);
+  $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)
         {
         // TODO !!
                 
-  while ($row = $sql -> fetch_array())
+  while ($row = mysql_fetch_array($sql))
           {
             switch ($row["category"]) 
@@ -269 +273 @@
           }
                   
-mysql_connect($db_server, $db_user, $db_pass);
-  mysql_select_db($db_webu);
-  $limit = 5;
+
 $pocet = mysql_result(mysql_query(" SELECT FOUND_ROWS()"), 0);
 if ($_GET["offset"]) {