summaryrefslogtreecommitdiffstats
path: root/frontends/php/include/hosts.inc.php
diff options
context:
space:
mode:
authorhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2006-05-08 13:59:48 +0000
committerhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2006-05-08 13:59:48 +0000
commit8e31e9456753eb36e2630ddbb723581d8ca99f44 (patch)
treeb0cc968dafba4745252536215f77d4f871fac9eb /frontends/php/include/hosts.inc.php
parentd1c144826a50eed1910a1d5b02a530359a68f105 (diff)
Minor changes.
git-svn-id: svn://svn.zabbix.com/trunk@2820 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'frontends/php/include/hosts.inc.php')
-rw-r--r--frontends/php/include/hosts.inc.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/frontends/php/include/hosts.inc.php b/frontends/php/include/hosts.inc.php
index 2f31cb34..00e9eb95 100644
--- a/frontends/php/include/hosts.inc.php
+++ b/frontends/php/include/hosts.inc.php
@@ -462,9 +462,9 @@
if($groupid == 0)
{
- $sql = "select h.hostid,h.host from hosts h".$item_table.
+ $sql = "select distinct h.hostid,h.host from hosts h".$item_table.
" where h.status<>".HOST_STATUS_DELETED.$with_host_status.$with_items.
- " group by h.hostid order by h.host";
+ " order by h.host";
$db_hosts = DBselect($sql);
while($db_host = DBfetch($db_hosts))