Hi there,

I am wondering if it would be possible to get the amount of different values
in one sql command.
E.g.:
field age: 0,3,5,5,2,3

Sql querry should return how often 3 occurs. Which would be 2. And as well
the other values... 1 for agestructure 2 becuase it occures only once.

I wrote following querry

  $stmt="
   SELECT COUNT(*) AS c
   FROM $T5
   WHERE age = 4
  ";
  $row  = db_get_row2($stmt);
  $age_4 = $row->c;

This returns only the value for 4. To get all values (10 different ones) I
would have to make 10 querrys, right?

Is there a faster way?

Thanx for any help,

Andy



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to