| |
|
|
| |
SELECT count(email) as ct1
FROM dle_users
WHERE allow_mail = '1'
UNION SELECT count(email) as c2
FROM `subscribes`
WHERE allow =1
LIMIT 0 , 30
|
Хочу на выходе получить сt1+ch2 | |
| |
|
|
| |
|
|
| |
для: OLi
(12.03.2012 в 21:21)
| | | можно так
SELECT r1.ct1 + r2.c2 FROM
( SELECT count(email) as ct1
FROM dle_users
WHERE allow_mail = '1'
) r1,
( SELECT count(email) as c2
FROM `subscribes`
WHERE allow =1
) r2
|
| |
| |
|
|
| |
|
|
| |
для: Sfinks
(12.03.2012 в 22:02)
| | | а на выходе как получить $row[]? | |
| |
|
|
| |
|
|
| |
для: OLi
(12.03.2012 в 22:30)
| | | Спасибо - сделал | |
| |
|
|
| |
|
|
| |
для: Sfinks
(12.03.2012 в 22:02)
| | | _ | |
| |
|
|
