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.
fields: userid, username, firstname, lastname
fields: id, filename, userid*
I don't know if this is clear enough, but I'll give it a shot