Revize 96b3e7ed

Re #7580 arabic průběžné úpravy

old/html/multidic/examination/article.php

@@ -129 +129 @@
 }
 
 function build_query_article($language, $contrains_source, $contrains_lection,$order, $od, $limit) {
-	  $dotaz = "SELECT DISTINCT ON (ar.\"IDarticle\")
-                         ar.\"IDarticle\"  as \"IDarticle\",
+	  $dotaz = "SELECT DISTINCT 
+                         ar.IDarticle  as IDarticle,
                          ar.title          as title,
                          lan.language      as language,
                          so.title          as source,
@@ -149 +149 @@
   if ($contrains_lection != "all")
     $dotaz .= "AND ar.lection = $contrains_lection";
 
-  $dotaz .= " AND ar.language = lan.\"IDlanguage\"
-              AND ar.source   = so.\"IDsource\" ";
+  $dotaz .= " AND ar.language = lan.IDlanguage
+              AND ar.source   = so.IDsource ";
   if (!empty($order)) {
-  	$orderClause = "ar.\"IDarticle\", \"$order\"";
+  	$orderClause = "ar.IDarticle, $order";
   }
   else {
-    $orderClause = "\"IDarticle\"";
+    $orderClause = "IDarticle";
   }
 
-  $dotaz .= " ORDER BY $orderClause OFFSET $od LIMIT $limit";
+  $dotaz .= " ORDER BY $orderClause LIMIT $limit OFFSET $od";
 
   return $dotaz;
 } // END function build_query_article
@@ -170 +170 @@
   $spojeni = new DB_Sql();
 	$dotaz = build_query_article($language, $contrains_source, $contrains_lection,$order, $od, $limit);
   $radky = $spojeni->query($dotaz);
-  while ($spojeni->next_record()) {
-    //print_r($spojeni->Record);
-    if (!empty($spojeni->Record['title'])) {
-	    $navrat .= "<a href=\"?language=".$_REQUEST['language']."&amp;view_article=".$spojeni->Record['IDarticle']."\">".$spojeni->Record['title']."</a><br />";
+  foreach ($radky as $radka){
+    if (!empty($radka['title'])) {
+	    $navrat .= "<a href=\"?language=".$_REQUEST['language']."&amp;view_article=".$radka['IDarticle']."\">".$radka['title']."</a><br />";
 	}
   }
 	return $navrat;