[MySQL][PHP] count Opcje

[Chelo]

Jak mogę użyć kilka/naście razy funkcję count() w jednym zapytaniu?

próbowałem:

[PHP] pobierz, plaintext 
SELECT COUNT(a.post_id) AS totalp, COUNT(b.user_id) AS totalus, COUNT(c.topic_id) AS totaltopics, COUNT(d.privmsgs_id) AS totalpw, COUNT(e.sb_user_id) AS totalshoutbox 
FROM phpbb_posts a, phpbb_users b, phpbb_topics c, phpbb_privmsgs d, phpbb_shoutbox e
[PHP] pobierz, plaintext 

wszystko się mnoży i dlatego też nie działa, tak jak należy.

Proszę o pomoc

[athei]

[SQL] pobierz, plaintext 
SELECT COUNT(post_id) AS totalp, (SELECT COUNT(b.user_id) AS totalus FROM phpbb_users ), (SELECT COUNT(topic_id) AS totaltopics FROM phpbb_topics), (SELECT COUNT(privmsgs_id) AS totalpw FROM  phpbb_privmsgs ), (SELECT COUNT(sb_user_id) AS totalshoutbox FROM phpbb_shoutbox) FROM  phpbb_posts;
[SQL] pobierz, plaintext 

Ten post edytował athei 20.02.2010, 17:57:13

[Chelo]

popełniłeś literówkę, ale mniejsza o to.

Teraz jest problem z wyświetleniem wyników. Otóż przy print_r:

[PHP] pobierz, plaintext 
Array ( [totalp] => 6 [(SELECT COUNT(user_id) AS totalus FROM phpbb_users )] => 5 [(SELECT COUNT(topic_id) AS totaltopics FROM phpbb_topics)] => 6 [(SELECT COUNT(privmsgs_id) AS totalpw FROM phpbb_privmsgs )] => 1 [(SELECT COUNT(sb_user_id) AS totalshoutbox FROM phpbb_shoutbox)] => 5 )
[PHP] pobierz, plaintext 

natomiast gdy:

[PHP] pobierz, plaintext 
$template->assign_vars(array(
"IP" => $row6['totalp'],
"IU" => $row6['totalus'],
"IT" => $row6['totaltopics'],
"IPW" => $row6['totalpw'],
"ISB2" => $row6['totalshoutbox']));
[PHP] pobierz, plaintext 

działają tylko ilość postów i wyswietleń tematów z wiadomych przyczyn.

tylko jak to naprawić?, w tej sytuacji nie działają As'y.

Proszę o pomoc

[athei]

Moje niedopatrzenie z nawiasami:

[SQL] pobierz, plaintext 
SELECT COUNT(post_id) AS totalp, (SELECT COUNT(user_id) FROM phpbb_users ) AS totalus, (SELECT COUNT(topic_id)  FROM phpbb_topics) AS totaltopics, (SELECT COUNT(privmsgs_id) FROM  phpbb_privmsgs ) AS totalpw, (SELECT COUNT(sb_user_id) FROM phpbb_shoutbox)AS totalshoutbox FROM  phpbb_posts;
[SQL] pobierz, plaintext 

Teraz powinno działać.