public static function getLstSigned($id_user) { $lst = array(); global $db; $sel = "SELECT DISTINCT g.*\n FROM " . self::TABLE_NAME . " g\n INNER JOIN " . diplo_player_game::TABLE_NAME . " lk\n ON g.id = lk.id_game\n WHERE lk.id_player = {$id_user}\n ORDER BY g.name"; $res = $db->query($sel); $lst = array(); while ($r = $res->fetchArray()) { $game = new diplo_game(); $game->openFromResultSet($r); $lst[] = $game; } return $lst; }