Online brugere skal vises i øverst række

Kode 

CREATE TABLE `venner` (
  `id` int(11) NOT NULL auto_increment,
  `brugernavn` varchar(32) collate latin1_general_ci NOT NULL,
  `ven` varchar(32) collate latin1_general_ci NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=5 ;

-- 
-- Data dump for tabellen `venner`
-- 

INSERT INTO `venner` VALUES (1, 'Kampmann', 'Hygge');
INSERT INTO `venner` VALUES (2, 'Hygge', 'Kampmann');
INSERT INTO `venner` VALUES (3, 'Kampmann', 'Steven');
INSERT INTO `venner` VALUES (4, 'Steven', 'Kampmann');


CREATE TABLE `online_brugere` (
  `id` int(11) NOT NULL auto_increment,
  `brugernavn` varchar(32) collate latin1_general_ci NOT NULL,
  `tid` int(11) NOT NULL,
  `venner` int(11) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4 ;

-- 
-- Data dump for tabellen `online_brugere`
-- 

INSERT INTO `online_brugere` VALUES (3, 'Kampmann', 1196346731, 3);

--
-- Select
--

SELECT venner.id, venner.brugernavn, venner.ven
FROM venner, online_brugere
WHERE venner.id = onlinebrugere.venner ORDER BY online_brugere.tid DESC

Kode 

CREATE TABLE `online_brugerez` (
  `id` int(11) NOT NULL auto_increment,
  `brugernavn` varchar(32) collate latin1_general_ci NOT NULL,
  `tid` int(11) NOT NULL,
  `vennerz` int(11) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4 ;

-- 
-- Data dump for tabellen `online_brugerez`
-- 

INSERT INTO `online_brugerez` VALUES (3, 'Kampmann', 1196346731, 3);

--
-- Select
--

SELECT vennerz.id, vennerz.brugernavn, vennerz.ven
FROM vennerz, online_brugerez
WHERE vennerz.id = onlinebrugerez.vennerz ORDER BY online_brugerez.tid DESC

Kode 

SELECT brugernavn FROM users u
JOIN venner v ON u.id = v.id OR u.id = v.friend
JOIN users uv ON v.friend = uv.id
WHERE u.id = 1
ORDER BY uv.online DESC