Agrupar registros

[f4b14n]

Prueba usando esto

Código PHP:

<?php
$link = mysql_connect("localhost", "root", "");
mysql_select_db("pruebas", $link);
 
$items = array( "n1" => "Muy Bajo",
                "n2" => "Bajo",
                "n34" => "Moderado",
                "n5" => "Alto");
 
$sql = "SELECT
        (SELECT count(*) AS cant  FROM  t_motivo as tmp  WHERE puntuacion = 1) AS n1, 
        (SELECT count(*) AS cant  FROM  t_motivo as tmp  WHERE puntuacion = 2) AS n2, 
        (SELECT count(*) AS cant  FROM  t_motivo as tmp  WHERE (puntuacion = 3 OR puntuacion = 4)) AS n34,
        (SELECT count(*) AS cant  FROM  t_motivo as tmp  WHERE puntuacion >= 5) AS n5
        FROM t_motivo
        LIMIT 0,1";
        
$result_p=mysql_query($sql, $link) or die (mysql_error());
$row = mysql_fetch_array($result_p);
 
foreach ($items as $key => $puntuacion)
{
    echo "[$puntuacion - Total: {$row[$key]}]<br / >";
}
 
?>