<?php include_once("include/db.php"); # Return list of users function getAdminRealms($params) { global $db; $sql = "SELECT ID, Name, Disabled FROM realms"; $res = $db->query($sql); $resultArray = array(); # loop through rows while ($row = $res->fetchObject()) { $item = array(); $item['ID'] = $row->id; $item['Name'] = $row->name; $item['Disabled'] = $row->disabled; # push this row onto array array_push($resultArray,$item); } # get number of rows $sql = "SELECT count(*) FROM realms"; $res = $db->query($sql); $numResults = $res->fetchColumn(); return array($numResults,$resultArray); } ?>