users key and images table php

[Dusty_Rods]

Hi guys first post 😃 ,

Ok so i have 3 tables.

users
key
images

both users and images have a reference number.

in the key table the reference numbers are twinned together. user can have more than one image, an image can only have be twinned to a user.

so in the key if a user had and id of 23 it look like this

key table

userid imageid
23 45
23 56
23 78
23 101

So what i want to do is set up a search system for users. Once you click into the users you can see if any images are associated to him. If there are i want to show only the newest 6 images. this is controlled by a date_added field within the images table.

Anyone coded a few php like this before? any help would be greatly aappricated.

Thanks in advance.
Dusty...

[subwayman]

SELECT imageid FROM key WHERE userid=$userid order by date_added DESC limit 6