//============================================================================================= // //============================================================================================= function GetList($grp = '') { $srv = 'xxx.xxx.xxx'; $id = 'xxx'; $pwd = 'xxx'; $dbn = 'xxx'; $link = mysqli_connect($srv, $id, $pwd, $dbn); if (mysqli_connect_errno()) { die('Connect failed: ' . mysqli_connect_error()); } if ($grp == '') { $sql = 'SELECT `id`,`name`,`exp` FROM `Links` ORDER BY `cnt` DESC'; } else { $sql = 'SELECT `id`,`name`,`exp` FROM `Links` WHERE `grp` = "' . $grp . '" ORDER BY `cnt` DESC'; } if ($rs = mysqli_query($link, $sql)) { $ret_list = array(); while ($row = mysqli_fetch_array($rs, MYSQLI_ASSOC)) { $ret_list[] = array('id'=>$row['id'], 'name'=>$row['name'], 'exp'=>$row['exp']); } mysqli_free_result($rs); } mysqli_close($db); return $ret_list; }