[ byM4k5 @ 09.07.2005. 12:19 ] @
Imam jedan sitan problem. Problem sam pokusao naci u litaraturi i arhivi foruma, ali izgleda da sam trazio na pogresnom mjestu ili je to nemoguce. Imam dvije tabele, "korisnici" i "slike".

Code:
+----+----------+
| id | username |
+----+----------+
|  1 |    marko |
+----+----------+
|  2 |    mirko |
+----+----------+

+----+---------+-------+
| id | user_id | slika |
+----+---------+-------+
|  1 |       1 | 1.jpg |
+----+---------+-------+
|  2 |       1 | 2.jpg |
+----+---------+-------+
|  3 |       1 | 3.jpg |
+----+---------+-------+
|  4 |       2 | 4.jpg |
+----+---------+-------+
|  5 |       2 | 5.jpg |
+----+---------+-------+
|  6 |       1 | 6.jpg |
+----+---------+-------+


Kako postaviti query da dobijem:

Code:
+----+----------+------+
| id | username | broj |
+----+----------+------+
|  1 |    marko |    4 |
+----+----------+------+
|  2 |    mirko |    2 |
+----+----------+------+

[ SmilieBG @ 09.07.2005. 14:16 ] @
Pogledaj sum(tabela), group by i order by... nisam siguran kako ide, nesto sam pokusao, ali iskreno mrzi me :)

Poz,
Sale
[ Dejan Topalovic @ 09.07.2005. 15:38 ] @

mysql> SELECT korisnici.id, username, COUNT(*)
-> FROM slike, korisnici
-> WHERE korisnici.id = slike.user_id
-> GROUP BY slike.user_id;
+------+----------+----------+
| id | username | COUNT(*) |
+------+----------+----------+
| 1 | marko | 4 |
| 2 | mirko | 2 |
+------+----------+----------+
2 rows in set (0.00 sec)
[ byM4k5 @ 10.07.2005. 00:05 ] @
Zahvaljujem. Nisam znao da se ovo rijesava sa GROUP BY... :(