[Resolved] Counting values in a mysql result

[no_maam]

$sql=mysql_query("SELECT client_id  FROM invoices WHERE amount >'$amount' ");

I wonder if there is a way of counting how many times a specific client_id is returned.
For instance i want to know how manny times the user X has bought more than 5 products.
Thanks!

[drew010]

$sql=mysql_query("SELECT client_id  FROM invoices WHERE amount >'$amount' ");
$data = mysql_fetch_array($sql);

$counts = array_count_values($data['client_id']);

if (isset($counts['drew010'])) {
  echo $counts['drew010'];
} else {
  echo "0";
}

that should do what you want it to do. the client_id will become an array index in $counts and it will hold the number of times the client id shows up in the resultset. so if i bought things 5 times from you over that $amount, echo $counts['drew010'] would print out 5.

[no_maam]

Thanks a lot drew010!
😃