Query 3 tables

[Terminator]

Hi,

I can't figure the followign problem

I have 3 tables

media

• id

• userid

• title

• previews

Value :

"1", "2", "Test Title", "1,2,3"

Notice previews has 1,2,3 as value

users

• userid

• username

Value :

"1", "admin"
"2", "user"

previews

• id

• filename

"1", "file1.jpg"
"2", "file2.jpg"
"3", "file3.jpg"

Now I want to have the last 15 from media, with the correct userid and previews (filename).

I used IN

SELECT a.id, a.userid, a.title, a.previews, a.tags, a.views, a.added, b.uid, b.username, c.id AS previewid, c.filename FROM media a, mybb_users b, previews c WHERE a.userid=b.uid AND a.status='1' AND c.linkid IN ('a.previews') ORDER BY a.added DESC LIMIT 0,15

But his aint working, I got 1 result (the first).

[djjjozsi]

my suggestion is: lets use the JOIN to join 3 tables, and forget this database design.

try to change the previews to be able to store the media_id's:

previews table:
id
media_id
filename

1, 1,aaa.jpg
2, 1.bbb.jpg

and the select then change into an INNER JOIN