Просмотр поста #89258: Объединение запросов в один

if ($id) {
$req = mysql_query("SELECT * FROM `artist` WHERE `id` = '$id'");
if (mysql_num_rows($req)) {
$res1 = mysql_fetch_assoc($req);
$sort = $res1['count_album'];
$req = mysql_query("SELECT * FROM `artist` WHERE `count_album` > '$sort' ORDER BY `id` ASC LIMIT 1");
if (mysql_num_rows($req)) {
$res = mysql_fetch_assoc($req);
$id2 = $res['id'];
$sort2 = $res['count_album'];
mysql_query("UPDATE `artist` SET `count_album` = '$sort2' WHERE `id` = '$id'");
mysql_query("UPDATE `artist` SET `count_album` = '$sort' WHERE `id` = '$id2'");
}
}
}