Thanks Jason! I thought I needed a linking table like I described in post? This seems easier really but I don't know exaclty why! ;=) I'm a real newbie to PHP and MySQL yet but I'm learning new stuff every day!
I tried the code you gave me but I get error messege when testing the page:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.Media.ID WHERE users.UserID = -1' at line 1
My 2 tables are named: users and media
Table media has an ID field named: MediaID
In the users table I created a field named: UserMediaID
Come to think about it, I do have a separate table named accesslevels where I store the different levels (Admin, student, visitor). It has 2 fields, 1 ID field named AccessLevelsID and 1 named AccessLevelsName. In the users table I also have a field named UserAccessLevelsID then.
This is the problem right?
Regards,
Martin J.
