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".
Kako postaviti query da dobijem:
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 |
+----+---------+-------+
+----+----------+
| 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 |
+----+----------+------+
+----+----------+------+
| id | username | broj |
+----+----------+------+
| 1 | marko | 4 |
+----+----------+------+
| 2 | mirko | 2 |
+----+----------+------+