Ajuda com Select Count
Pessoal, boa tarde.
Preciso fazer uma contagem de registros, só que com filtros.
Queria saber como fazer sem fazer vários select.
Tipo preciso saber quantos registros tenho com IKS-0, quantos registros IKS-1, e assim vai até IKS-7.
Alguém pode me ajudar?
//**********************************************************************************************
$sql = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-0' ");
$r = mysql_query($sql);
$total = mysql_num_rows($r);
echo "Total IKS-0: ".$total;
echo "<br>";//**********************************************************************************************
//**********************************************************************************************
$sql1 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-1' ");
$r1 = mysql_query($sql1);
$total1 = mysql_num_rows($r1);
echo "Total IKS-1: ".$total1;
echo "<br>";//**********************************************************************************************
//**********************************************************************************************
$sql2 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-2' ");
$r2 = mysql_query($sql2);
$total2 = mysql_num_rows($r2);
echo "Total IKS-2: ".$total2;
echo "<br>";//**********************************************************************************************
//**********************************************************************************************
$sql3 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-1' ");
$r3 = mysql_query($sql3);
$total3 = mysql_num_rows($r3);
echo "Total IKS-3: ".$total3;
echo "<br>";//**********************************************************************************************
//**********************************************************************************************
$sql4 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-4' ");
$r4 = mysql_query($sql4);
$total4 = mysql_num_rows($r4);
echo "Total IKS-4: ".$total4;
echo "<br>";//**********************************************************************************************
//**********************************************************************************************
$sql5 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-5' ");
$r5 = mysql_query($sql5);
$total5 = mysql_num_rows($r5);
echo "Total IKS-5: ".$total5;
echo "<br>";//**********************************************************************************************
//**********************************************************************************************
$sql6 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-6' ");
$r6 = mysql_query($sql6);
$total6 = mysql_num_rows($r6);
echo "Total IKS-6: ".$total6;
echo "<br>";//**********************************************************************************************
//**********************************************************************************************
$sql7 = ("SELECT * FROM dia WHERE status = 'A' AND planejador = 'IKS-7' ");
$r7 = mysql_query($sql7);
$total7 = mysql_num_rows($r7);
echo "Total IKS-7: ".$total7;
echo "<br>";//**********************************************************************************************
Discussão (11)
Carregando comentários...