summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorINOPIAE <inopiae@cacert.org>2013-07-14 21:12:22 +0200
committerINOPIAE <inopiae@cacert.org>2013-07-14 21:12:22 +0200
commit7517a7273f5c8bd4f95bf6862d3093da86db105d (patch)
tree2800d29a19ba365e98e3f83338b9f3a48bcffa50
parent4c592d37ecda8e3f840b9c383af3a84113ed2bf7 (diff)
downloadcacert-devel-7517a7273f5c8bd4f95bf6862d3093da86db105d.tar.gz
cacert-devel-7517a7273f5c8bd4f95bf6862d3093da86db105d.tar.xz
cacert-devel-7517a7273f5c8bd4f95bf6862d3093da86db105d.zip
bug 1010: Changed Order by in SQL-statement
-rw-r--r--pages/account/18.php2
-rw-r--r--pages/account/22.php2
2 files changed, 2 insertions, 2 deletions
diff --git a/pages/account/18.php b/pages/account/18.php
index 7d352ba..e1b92a5 100644
--- a/pages/account/18.php
+++ b/pages/account/18.php
@@ -36,7 +36,7 @@ $status = array_key_exists('status',$_SESSION['_config']) ? intval($_SESSION['_c
<? $query = "select `orginfo`.`O`, `orginfo`.`id`
from `org`, `orginfo`
where `org`.`memid`='".intval($_SESSION['profile']['id'])."' and `orginfo`.`id` = `org`.`orgid`
- ORDER BY `oemail`.`modified` desc";
+ ORDER BY `orginfo`.`O` ";
$reso = mysql_query($query);
if(mysql_num_rows($reso) >= 1){
while($row = mysql_fetch_assoc($res)){
diff --git a/pages/account/22.php b/pages/account/22.php
index 30aa542..2c159f6 100644
--- a/pages/account/22.php
+++ b/pages/account/22.php
@@ -35,7 +35,7 @@ $status = array_key_exists('dstatus',$_SESSION['_config']) ? intval($_SESSION['_
<? $query = "select `orginfo`.`O`, `orginfo`.`id`
from `org`, `orginfo`
where `org`.`memid`='".intval($_SESSION['profile']['id'])."' and `orginfo`.`id` = `org`.`orgid`
- ORDER BY `oemail`.`modified` desc";
+ ORDER BY `orginfo`.`O` ";
$reso = mysql_query($query);
if(mysql_num_rows($reso) >= 1){
while($row = mysql_fetch_assoc($res)){