Changeset 12445 for trunk/www/db_po

Timestamp:

11/07/11 12:02:51 (13 years ago)

Author:

Daniela Dorner

Message:

changed sorting of po list to fix bug in compare

File:

• trunk/www/db_po/get_values.php (modified) (2 diffs)

trunk/www/db_po/get_values.php

@@ -60 +60 @@
     $query0 ="SELECT fIndex, fValidFrom, fProgram, Concat(fKey1,fKey2), fValue, ";
     $query0.="fDescription, fCounter, fType, fMin, fMax, fKey1, SUBSTRING(fKey2,2), ";
-    $query0.="if(fOriginalIndex=0, fIndex, fOriginalIndex), fUser FROM ProgramOption ";
+    $query0.="if(fOriginalIndex=0, fIndex, fOriginalIndex) as MyIndex, fUser FROM ProgramOption ";
     $query0.="WHERE 1=1 ";
     if (strcmp($_GET["fKey"],"all")!=0)
@@ -73 +73 @@
             $query0.=" AND (fValidFrom < '".$_GET["fStatusDate"]."' OR fValidFrom like '".$_GET["fStatusDate"]."%') ";
     }
-    $query0.=" ORDER BY fOriginalIndex, fIndex";
+    $query0.=" ORDER BY MyIndex ";
 
     $result0=mysql_query($query0, $db_id);