Usamos cookies para medir audiência e melhorar sua experiência. Você pode aceitar ou recusar a qualquer momento. Veja sobre o iMasters.
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>";Carregando comentários...