Вообщем вот код:
connect();
mysql_query("CREATE TEMPORARY TABLE gamerating (
userID int(11) NOT NULL default \'0\',
day date NOT NULL default \'0000-00-00\',
race1 double NOT NULL default \'0\',
race2 double NOT NULL default \'0\',
race3 double NOT NULL default \'0\',
race4 double NOT NULL default \'0\'
)");
mysql_query("INSERT INTO gamerating VALUES (340, \'2002-07-10\', \'81.32123\', \'120.234\', \'116.233\', \'130.1234\'),
(36319, \'2002-07-10\', \'97.8390000000002\', \'93.517\', \'112.562999999999\', \'150.839\'),
(9158, \'2002-07-10\', \'83.0919999999999\', \'92.8869999999996\', \'105.203\', \'132.457999999999\'),
(9158, \'2002-07-10\', \'86.4840000000001\', \'90.2049999999998\', \'98.5719999999996\', \'132.198999999999\'),
(38055, \'2002-07-12\', \'85.5940000000003\', \'93.732\', \'105.973999999999\', \'136.714999999999\'),
(38120, \'2002-07-15\', \'82.7569999999996\', \'92.4009999999996\', \'108.804999999999\', \'154.802\'),
(208, \'2002-07-15\', \'85.9570000000006\', \'95.6819999999997\', \'108.683\', \'143.043999999999\'),
(38055, \'2002-07-15\', \'83.6909999999999\', \'92.2600000000002\', \'103.247999999999\', \'135.828999999999\'),
(38055, \'2002-07-16\', \'84.9290000000004\', \'88.873\', \'98.5359999999997\', \'138.563999999999\'),
(9158, \'2002-07-17\', \'80.366\', \'81.8229999999997\', \'91.3629999999997\', \'124.497999999999\')
");
mysql_query("CREATE TEMPORARY TABLE tmp SELECT * FROM gamerating WHERE 1=0");
$r=mysql_query("SELECT min(race1+race2+race3+race4) as total, userID from gamerating group by userID");
for($i=0;$i<mysql_num_rows($r);$i++){
$f=mysql_fetch_array($r);
mysql_query("INSERT INTO tmp SELECT * FROM gamerating WHERE userID=$f[userID] AND ROUND((race1+race2+race3+race4), 5)=ROUND($f[total], 5)");
}
$r=mysql_query("SELECT *, (race1+race2+race3+race4) as total FROM tmp");
for($i=0;$i<mysql_num_rows($r);$i++){
$f=mysql_fetch_array($r);
for($j=0;$j<mysql_num_fields($r);$j++) echo $f[$j]."|";
echo "<BR>";
}А вот результат:
208|2002-07-15|85.9570000000006|95.6819999999997|108.683|143.043999999999|433.366|
340|2002-07-10|81.32123|120.234|116.233|130.1234|447.91163|
9158|2002-07-17|80.366|81.8229999999997|91.3629999999997|124.497999999999|378.05|
36319|2002-07-10|97.8390000000002|93.517|112.562999999999|150.839|454.758|
38055|2002-07-16|84.9290000000004|88.873|98.5359999999997|138.563999999999|410.902|
38120|2002-07-15|82.7569999999996|92.4009999999996|108.804999999999|154.802|438.765|
нафига круглить
Мы что с тобой в космос отправляемся? :-)