www/includes/global.inc.php

changeset 36
4b829f689d7e
parent 34
a720353fada9
child 39
400aae9fb0c8
--- a/www/includes/global.inc.php	Fri Aug 24 23:00:15 2018 +0200
+++ b/www/includes/global.inc.php	Sat Aug 25 11:40:31 2018 +0200
@@ -92,7 +92,7 @@
 	<ul>
 <?php
 $mysqli = new mysqli(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
-$result = $mysqli->query("SELECT uuid,node,online,net_address FROM nodes");
+$result = $mysqli->query("SELECT uuid,node,online,net_address FROM nodes ORDER BY node");
 while($row = $result->fetch_array(MYSQLI_ASSOC)) {
     echo '         <li><a href="mon_node.php?uuid='.$row['uuid'].'">'.$row['node'].'</a></li>'.PHP_EOL;
 }
@@ -103,7 +103,7 @@
        <li>Klimaatkasten
 	<ul>
 <?php
-$result = $mysqli->query("SELECT uuid,node,alias,online,mode FROM fermenters");
+$result = $mysqli->query("SELECT uuid,node,alias,online,mode FROM fermenters ORDER BY node,alias");
 while($row = $result->fetch_array(MYSQLI_ASSOC)) {
     echo '         <li><a href="mon_fermenter.php?uuid='.$row['uuid'].'">'.$row['node'].'/'.$row['alias'].'</a></li>'.PHP_EOL;
 }

mercurial