[ 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 | +----+----------+------+ |