php - why does count function return one row? -
i have query using pdo
"select category.id id, category.static_name   static_name,   category.name name, count(training.id) trainings_count         category         join training   on training.cat_id = category.id"   when columns empty, count function returns 1 row , whole function return true. solution problem ?
if don't group answers category, count returned , give 1 answer. way aggregate functions (count, sum, min, max, etc.) supposed function.
so question is, want count of.  add clause group <blah> <blah> item wanting count items of.
Comments
Post a Comment