[HaBo]

CREATE TABLE IF NOT EXISTS `uptime` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user_id` int(10) unsigned NOT NULL,
  `pc_id` int(10) unsigned NOT NULL,
  `start` int(10) unsigned NOT NULL,
  `last` int(10) unsigned NOT NULL default '0',
  `active` tinyint(1) unsigned NOT NULL default '1',
  `uptime` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `last` (`last`)
)

SELECT <hauen zeug>,(select count(id) from uptime where uptime > u.uptime and active = 1)+1 as rank
                  FROM pc as p
                  left outer JOIN uptime as u ON p.id = u.pc_id
                  WHERE p.user_id = '$id' and (u.active = 1 OR u.active is NULL)

SET @counter:=0;
SELECT (@counter:=@counter+1) AS 'Nummerierung', <weitere spalten> FROM tabelle