diff options
| author | INOPIAE <inopiae@cacert.org> | 2013-07-14 21:12:22 +0200 |
|---|---|---|
| committer | INOPIAE <inopiae@cacert.org> | 2013-07-14 21:12:22 +0200 |
| commit | 7517a7273f5c8bd4f95bf6862d3093da86db105d (patch) | |
| tree | 2800d29a19ba365e98e3f83338b9f3a48bcffa50 /pages/account | |
| parent | 4c592d37ecda8e3f840b9c383af3a84113ed2bf7 (diff) | |
| download | cacert-devel-7517a7273f5c8bd4f95bf6862d3093da86db105d.tar.gz cacert-devel-7517a7273f5c8bd4f95bf6862d3093da86db105d.tar.xz cacert-devel-7517a7273f5c8bd4f95bf6862d3093da86db105d.zip | |
bug 1010: Changed Order by in SQL-statement
Diffstat (limited to 'pages/account')
| -rw-r--r-- | pages/account/18.php | 2 | ||||
| -rw-r--r-- | pages/account/22.php | 2 |
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)){ |