SELECT SUM(field1) FROM table GROUP BY fieldDistinctSELECT DISTINCT fieldDistinct1, fieldDistinct2 FROM table$id = $_COOKIE['user_id'];
if ($id) {
//код
}unset($_COOKIE['user_id']);//удалится Cookie
<?
$nick = 'Player1';//твой ник
$q = mysql_fetch_assoc(mysql_query("SELECT * FROM `таблица` WHERE `nick` = '".$nick."'"));
$jobs = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `таблица` WHERE `jobs` > '".$q['jobs']."'"), 0);
$distance= mysql_result(mysql_query("SELECT COUNT(`id`) FROM `таблица` WHERE `distance` > '".$q['distance']."'"), 0);
$totalmass = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `таблица` WHERE `totalmass` > '".$q['totalmass']."'"), 0);
echo 'Позиция '.$jobs.' по колонке jobs<br/>';
echo 'Позиция '.$distance.' по колонке distance<br/>';
echo 'Позиция '.$totalmass .' по колонке totalmass ';
?>$b = '2,4,3';
$b = explode(",", $b);
for($i = 0; $i < count($b); $i++)
{
$r = mysql_fetch_assoc(mysql_query("SELECT `A` FROM `простая таблица из 4х строк` WHERE `B` = '".$b[$i]."'"));
if(isset($res) && $res == $r['A'])
{
$res = $r['A'];
}
if(isset($res) && $res != $r['A'])
{
unset($res);
break();
}
}
echo $res;