php ablum with thumbnail

[sanlove]

please help me to code image album with thumbnail.

attached image for help.

Edited January 26, 2014 by sanlove

[adam_bray]

What code have you tried so far?

[Barand]

I'll start you off with query needed. I am a bit confused by user 10 appearing twice in the output so I am assuming you want the output order by service

SELECT u.int_uid
    , u.str_uname
    , s.str_sname
    , p.str_imagename
FROM tbl_user u
    INNER JOIN tbl_service s USING (int_uid)
    INNER JOIN tbl_photos p USING (int_sid)
ORDER BY s.str_sname

[sanlove]

thanks . 

my problem is not with the query.

 

if one user has different services and each service has multiple images.

example id user-1 has 2 services, service-1 and service-3. output willbe

 

 

output from query

service1 userid1 image1

service1 userid1 image2

service1 userid1 image3

service3 userid1 image1

service3 userid1 image2

service3 userid1 image3 etc.

 

using php code i need to display

service1 userid1 (image1,image2,image3) then

service3 userid1 (image1,image2,image3)

 

please help.

Edited January 26, 2014 by sanlove

[Ch0cu3r]

You'll need to add extra logic to your while loop so it only displays the service and name once, and then lists the images,

[Barand]

Easiest way is to store the data in an array as you loop through the query results

$data[$service][$user][] = $image

Then use a couple of nested foreach loop to display the data

[sanlove]

if possible please give code.

thanks in advance.

[Barand]

Have a try yourself first and come back when you get stuck