Resolve User IDs

[D_tunisia]

I've got a list of usernames with ID numbers in one table i.e.

ID Username
1 Bob
2 Dave
3 Jim

And a separate table with news posts which have text in one field and the ID of the user who posted that info in another.

I am easily able to display the user ID on any page I want but I need it to be able to compare the user ID from the posts table to the username table and display the username rather than just the ID.

Anyone have any clever ideas?

Thanks in advance!

[sid]

you are looking for a join. can you give us the structure of your post and user table?

[D_tunisia]

The database is called 'ittechni_main'

The users table is called 'dbUsers' and the fields are:

id username password email

The posts table is called 'posts' and the fields are:

id user_id title text

I want to 'resolve' the id from 'dbUsers' to the user_id from 'posts'.

Hope this helps!