Hi!
I have som problems with outputting some data from a MySQL-db using PHP.

Let's say I have 2 tables. user and assignment(delivered assignments). What I need is to list out all the users, those who have delivered an assignment should have the filename listed next to their name.

users:
fields: userid, username, firstname, lastname

assginments:
fields: id, filename, userid*

I don't know if this is clear enough, but I'll give it a shot

Cheers,
Einar