3 запроса обьединить в 1

@45king · Регистрация: 29.08.2011

PHP

$sun=mysql_query ("(SELECT COUNT(*) AS counttitle FROM novosti) UNION (SELECT COUNT(*) as comment_count FROM comment) UNION (SELECT COUNT(*) AS user FROM userlist) UNION (SELECT COUNT(*) AS nik FROM sesios_online)");

народ правильно сделал а как щас вывести все три запроса

Vovan-VE · 01.11.2011, 16:05

SQL

SELECT
  `n`.`cnt` AS `novosti_count`,
  `c`.`cnt` AS `comments_count`,
  `ul`.`cnt` AS `users_count`,
  `so`.`cnt` AS `online_count`
FROM
  (SELECT COUNT(*) AS `cnt` FROM `novosti`) AS `n`,
  (SELECT COUNT(*) AS `cnt` FROM `comment`) AS `c`,
  (SELECT COUNT(*) AS `cnt` FROM `userlist`) AS `ul`,
  (SELECT COUNT(*) AS `cnt` FROM `sesios_online`) AS `so`

Честно говоря, не знаю, насколько это оправдано.

Опции темы