Cześć.
Próbuje wylistowac proste zapytanie.
Mam tabele "users" i kolumny: "name" i "payment" = (1/0)
Chcę wylistować i zliczyć ile takich samych "name" ma payment = 0 a ile payment = 1.
Nie wiem w jaki sposób dać możliwość wyświetlania coś na zasadzie: "WHERE payment = 1 or 2"
$query=mysql_query('SELECT DISTINCT(COUNT(*)) AS how, name FROM users WHERE category = "1" group by name'); while($result=mysql_fetch_array($query)) { echo 'Company: '.$result['name'].' - payment0: ? ? ? / payment1: ? ? ?<br>'; }
SELECT name, SUM(ilosc*(1-payment)) AS payment0, SUM(ilosc*(1-ABS(SIGN(payment-1)))) AS payment1 FROM (SELECT name,payment,COUNT(payment) AS ilosc FROM users GROUP BY name,payment) AS tmp GROUP BY name
Z jednym grupowaniem: http://sqlfiddle.com/#!9/1b24c/2
Bez COALESCE i CASE:
SELECT name, SUM(payment=0) AS payment0, SUM(payment=1) AS payment1 FROM users GROUP BY name;
Viagra Sildenafil Mujeres http://ilfrc.com Cytotec Abortion Buy Online In The Us
Powered by Invision Power Board (http://www.invisionboard.com)
© Invision Power Services (http://www.invisionpower.com)