Forum

Cod: Selectaţi tot

+----+--------+--------+
| ID | PRODUS | JUDET  |
+----+--------+--------+
|  1 |   P_1  | ALBA   |
|  2 |   P_1  | BRASOV |
|  3 |   P_2  | ALBA   |
|  4 |   P_1  | ARAD   |
|  5 |   P_3  | BRASOV |
|  6 |   P_4  | ALBA   |
|  7 |   P_1  | ARAD   |
+----+--------+--------+

Cod: Selectaţi tot

<?php
$ret =[];
$sql =".....";
$result = $conn->query($sql);
while($row = $result->fetch_assoc()){
	$ret[] =[$row['JUDET'], $row['COUNT']];
 }
?>

Cod: Selectaţi tot

ALBA; 3
BRASOV; 2
ARAD; 2

Cod: Selectaţi tot

$sql ="SELECT JUDET, COUNT(JUDET) AS cnt
FROM table GROUP BY JUDET";
$result = $conn->query($sql);
while($row = $result->fetch_assoc()){
  $ret[] =[$row['JUDET'], $row['cnt']];
}